Odoo 13 : Problems with one2many/many2one filters

This new "res.partner.contact" model contains the contact's name, date of birth and relationship to the "res.partner". And a "many2one" field of type "res.partner".

"res.partner" model definition

class ResPartner(models.Model):
    _inherit = "res.partner"
    _description="Partners"

    [...]
    contacts = fields.One2many('res.partner.contact', 'partner_id',string='Partner contacts')
    [...]

"res.partner.contact" model definition

class ResPartnerContact(models.Model): 
    _name = 'res.partner.contact'
    _description = "Contacts"

    [...]
    name = fields.Char(string="Name")    
    birthdate = fields.Date(string="Birthdate")
    partner_id = fields.Many2one('res.partner', string='Partner', ondelete='cascade')   
    [...]

In the definition of the "res.partner" search view, I'd like to add a filter to filter partners by it's contacts date of birth.

In fact, I want to filter out all partners whose contact's date of birth falls between two given dates.

I've tried several different filter definitions, but the wrong partners are filtered out.

(The contacts of the filtered partners have a date of birth outside the given date range).

Example of one the filter's domain I tried to declare in the res.partner search view

domain="[('contacts.birthdate', '>=', time.strftime('2019-07-31')),('contacts.birthdate', '<=', time.strftime('2020-08-01'))]"

When I apply this filter, literally one of the first results in the list of filtered "res.partner" contains a single contact whose date of birth is "2019-05-12". So the filter doesn't work.

If I put only one of the conditions in the domain, the filter works correctly.

The "&" operation does not appear to perform the join between the two conditions.

I can't add a field with fixed dates to facilitate the filter in the "res.partner.contact" model because these dates are likely to change from one year to the next.

Has anyone created filters with similar functionality?

Do you have any idea what I could do to achieve my goal, if possible?

Thank you in advance,

Mélanie

Tessa Roberts

Autor Najlepsza odpowiedź

Hi everyone,

Here's what I ended up doing to "solve" my problem.

I added a computed boolean field in the "res.partner.contact" model.

in_date_range = fields.Boolean('In date range', compute=_compute_field, search="_search_field")

Here are the compute and search functions for this field :

     from datetime import datetime, date
     
     def _compute_field(self):
        date_from = datetime.strptime('2019-08-01', "%Y-%m-%d")
        date_to = datetime.strptime('2020-07-31', "%Y-%m-%d")

        for record in self:
            if record.birthdate != False and record.birthdate >= date_from.date() and record.birthdate and record.in_date_range = True
            else:
                record.in_date_range = False

    def _search_field(self, operator, value):
        recs = self.search([]).filtered(lambda x : x.in_date_range is True)
        if recs:
            return [('id', 'in', [x.id for x in recs])]

In the search view of the "res.partner" model, I've added a filter with the following domain:

domain="[('contacts.in_date_range', '=', True)]"

I would have preferred to be able to search directly by dates, but that doesn't seem possible and this solution works.

The next step will be to make the search function dynamic by allowing the user to enter dates.

I'm going to close this post.

If by some miracle I find another solution, I might come and update it if I can.

Goodbye

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
Create/Update: a mandatory field is not set error many2one one2many Odoo13 mandatory-field	1 paź 23	2885
How do I put One2many after Many2one defined? - transient module states reset many2one one2many	1 mar 23	2268
Odoo Studio how to set a chain of multiple and related Many2one within a One2many lines many2one one2many	0 gru 22	2905
Automatically open many2one or one2many field without clicking external link icon code many2one one2many Odoo13 odoo13	0 paź 22	2110
filter according to comodel's fields many2one one2many	0 cze 21	2882

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!