Skip to Content
Вам необхідно зареєструватися, щоб взаємодіяти зі спільнотою.
All Posts Люди Значки
Мітки (View all)
odoo accounting v14 pos v15
Про цей форум
Це запитання позначене
many2onemany2manyv14
2 Відповіді
5636 Переглядів
Аватар
SmithJohn45

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
Найкраща відповідь

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', [])]}}



Аватар
Відмінити
SmithJohn45
Автор

thanks Kiran Mohan, will implement, check and give feedback here... :)

SmithJohn45
Автор

hi @Kiran Moha, sorry for late in reply, was busy in other tasks, today i tried to implement the code as your's but it is showing error. i want to copy my all 3 model's .py code and your code implemented with some changes. the error is " ValueError: Invalid domain term ('id', 'in', 'tests.brands(1, 2, 3)') " (without double quotes). don't know where i am making mistake due to lack of knowledge, please help. note: I can post the code as mentioned but this will not as readable here without formatting. regards

Kiran K

optional_products = self.product_id.optional_product_ids.ids

SmithJohn45
Автор

hi Kiran Mohan, this is same line as your first Answer here, if you want to see complete code i can post here as Answer ... because in Comment it is not possible imo.

Kiran K

Answer updated , it was optional_products = self.product_id.optional_product_ids earlier

SmithJohn45
Автор

thanks Kiran Mohan and appreciate your passions to help me :) regards

Аватар
Karan BK
Найкраща відповідь

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.



Karan BK

Junior Odoo Developer

Tel: +353 1 886 5684 (IE) +44 121 285 5684 (UK)  +91 964 381 7554 (IN)

Target Integration | CRM • ERP • Cloud

Website | LinkedIn | Twitter | Facebook | YouTube | Instagram

Аватар
Відмінити
Related Posts Відповіді Переглядів Дія
Hide some possible choices in a Many2one field
many2one v14
Аватар
Аватар
Аватар
2
квіт. 23
3660
Odoo 14: How i can set Domain filter on Many2one type field Вирішено
many2one v14
Аватар
Аватар
Аватар
2
лют. 25
42022
hide many2one record when changing condition
many2one v14
Аватар
Аватар
Аватар
2
лист. 22
3580
How to get Many2many records ids Вирішено
many2many v14
Аватар
Аватар
1
черв. 22
6633
Odoo 14: set filter of Many2one field onchange of another Many2one field
many2one v14
Аватар
Аватар
1
лют. 22
8579