How to filter records based on a parent field's id

Question

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 beneficiarie

Masood Zarei · Accepted 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.

Midhun Sankar P · 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)]}}

相關帖文	回覆	瀏覽次數
How to filter a many2many field on the Contact? 已解決 many2many filter_domain	3 3月 24	1832
Odoo16 CE: add search filter for CRM activity deadline through frontend filter_domain odoo16features	1 7月 23	2656
Singleton error for Odoo 16 in action 已解決 many2many singleton odoo16features	2 3月 24	2020
[SOLVED] How to make visible selected values in many2one or many2many fields on Settings page in Odoo 16 已解決 many2one many2many odoo16features	3 12月 23	6673
How to set filter on a pre-defined field of another model filter override filter_domain odoo16features	3 8月 23	3340

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！