ver.14: Many2one field how to filter from Many2many

Question

in "*Products*" (model product_template ) I have inherited and added a custom field "*brand_id*" of type " Many2many "
in my custom " OrderItems " I had a field "*brand_id*" as " Many2one ",
here user selects a "*product*" and for "*brand*" I want to 'filter' and show only " brands " which are associated to the selected "*product*" in "*Products*"
please help how to filter it.
regards

Kiran K · Accepted Answer

Hi ,
optional_product_ids is Many2many in Product Master
@api.onchange ( 'product_id' )
def  onchange_product_id ( self ):
if  self .product_id:
self .optional_id = False
optional_products = self .product_id.optional_product_ids.ids
if optional_products:
domain = [( 'id' , 'in' , optional_products)]
return  { 'domain' :{ 'optional_id' :domain}}
return  { 'domain' :{ 'optional_id' :[( 'id' ,  'in' , [])]}}

Karan BK · Answer

While defining *brand_id * field in the OrderItems, you can give domain such as
In OrderItems model
*brand_id = fields.Many2one(...., domain=[('id', 'in', product_id.brand_id.ids)])*
where product_id is the product field.

Bài viết liên quan	Trả lời	Lượt xem
Hide some possible choices in a Many2one field many2one v14	2 thg 4 23	2878
Odoo 14: How i can set Domain filter on Many2one type field Đã xử lý many2one v14	2 thg 2 25	40683
hide many2one record when changing condition many2one v14	2 thg 11 22	2925
How to get Many2many records ids Đã xử lý many2many v14	1 thg 6 22	5787
Odoo 14: set filter of Many2one field onchange of another Many2one field many2one v14	1 thg 2 22	7942

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!