Skip to Content
This question has been flagged
many2manyfilter_domainodoo16features
2 Respostes
3156 Vistes
Avatar
Masood Zarei

I added a new field to the res.partner model as follow:

beneficiary_ids = fields.Many2many('res.partner', 'res_partner_beneficiaries_rel', column1='col_1_partner', column2='col_2_beneficiary', ondelete='cascade' )

That's because each contact can have many beneficiaries and each beneficiary can be included in many contacts.

So, I can add some beneficiaries to a contact.

In another view in another module at first, I select a contact, and in the next field, I want to choose one of its beneficiaries. So, I need to filter contacts to see just the selected contact's beneficiaries in the previous field.

My questions: ​

​1) Is the Many2many relation correct(or such relation should be Many2one?why?)? 

​2) And, How can I set the right filter/domain? Now, I see all contacts in the second field.


Avatar
Descartar
Avatar
Masood Zarei
Autor Best Answer

This is the right answer I found at last:

@api.onchange('first_contact')

def_onchange_first_contact(self):

​return {'domain': {'next_contact': [('id', 'in', self.first_contact.beneficiary_ids.ids)]}}

No need to add anything else to the two fields.

Avatar
Descartar
Avatar
Midhun Sankar P
Best Answer

You can use onchange to get dynamic domain. 

@api.onchange('contact field')

def onchange_contact_field(self):

return {'beneficiary_ids': {'domain': [('id', 'in', self.contact_field.beneficiary_ids.ids)]}}


Avatar
Descartar
Masood Zarei
Autor

ok, thanks. I do that but still, have a problem.
what about 'next field' (see 'next filed' in line #7 of my description above)? Should I set *domain* on this field to call *onchange* function? how exactly?

Related Posts Respostes Vistes Activitat
How to filter a many2many field on the Contact? Solved
many2many filter_domain
Avatar
Avatar
Avatar
3
de març 24
1522
Odoo16 CE: add search filter for CRM activity deadline through frontend
filter_domain odoo16features
Avatar
Avatar
1
de jul. 23
2320
Singleton error for Odoo 16 in action Solved
many2many singleton odoo16features
Avatar
Avatar
Avatar
2
de març 24
1602
[SOLVED] How to make visible selected values in many2one or many2many fields on Settings page in Odoo 16 Solved
many2one many2many odoo16features
Avatar
Avatar
Avatar
3
de des. 23
6065
How to set filter on a pre-defined field of another model
filter override filter_domain odoo16features
Avatar
Avatar
Avatar
Avatar
3
d’ag. 23
2964