Skip to Content
Menu
This question has been flagged
3 Replies
3774 Views

i created many2many field in (mrp.bom model) that select multiply product from product.template based on boolean filed must be True,

i need to created many2one field in (mrp.production model) that select one record form selected product in many2many field in mrp.bom model

any idea how to do that ?

Avatar
Discard
Best Answer

Hi  loay elhaj,


You can use domain to filter the Many2one field,

product_ids = fields.Many2many('product.template')


product_id = fields.Many2one('product.template' , domain=[('id', 'in', product_ids.ids)])

where product_ids is the many2many field and product_id is the Many2one field. 


Hope it Helps,

Kiran K


Avatar
Discard
Author

but the product_ids and product_id in different models

Author

in mrp.bom is many2many and my other field that should be many2one in mrp.production

Then Try,

product_id = fields.Many2one('product.template' , domain=[('id', 'in', bom_id.product_ids.ids)])

Author

i've update the question see it again plz

Add Many2one field in mrp.production with domain

product_id = fields.Many2one('product.template' , domain=[('id', 'in', bom_id.product_ids.ids)])

Author

error raised
packing = fields.Many2one('product.template', domain=[('id', 'in', bom_id.product_ids.id)])
AttributeError: 'Many2one' object has no attribute 'product_ids' - - -

Best Answer

I solved this issue by returning many2one field domain depending on many2many field results on changing the desired field. Like following:

@api.onchange('product_id')
def _onchange_product_alternative_domain(self):
for line in self:
if line.product_id:
return {'domain': {'alternative_product_id': [('id', 'in', line.product_id.alternative_product_ids.ids)]}}

Here alternative_product_ids is many2many field.

Avatar
Discard
Author Best Answer

Error raised
ValueError: Invalid domain term ('id', 'in', 'bom_id.product_ids.ids')

Avatar
Discard
Related Posts Replies Views Activity
4
Jun 24
13895
2
Feb 25
4832
1
Dec 24
646
1
Nov 22
15406
3
Aug 22
12044