跳至內容
此問題已被標幟
ormquery
7 回覆
14929 瀏覽次數
頭像
Usman Farzand

i need to filter product which color is red & size is small 

self.env['product.template'].search([('name', '=', 'Product A"]),(attribuet_value,'=',''),], limit=1)

how i can search it ... any help

頭像
捨棄
Sehrish

You have to learn basic customization in odoo: https://github.com/sehrishnaz/learnopenerp/wiki

頭像
Gokulakrishnan Murugesan
最佳答案

Hi Usman,

Try this code,

products = self.env['product.template'].search([('attribute_line_ids.attribute_id', '=', "Color Name"),('attribute_line_ids.value_ids', 'in', "Small")], limit=1)

If you know the ID of Color and Size, You can use it directly.

Thanks

頭像
捨棄
頭像
Avinash Nk
最佳答案

Hi Usman,

Try this code.


products = self.env['product.product'].search([('name', '=', 'Product A'),
                                               ('attribute_value_ids.name', '=', 'red'),
                                               ('attribute_value_ids.name', '=', 'small')])

Thanks

頭像
捨棄
Hilar Andikkadavath

searching with the name? Please Update your answer.

Avinash Nk

Hi Hilar

What is wrong in the search for the name?

Hilar Andikkadavath

What if the name is get changed? Do you update the code in live server with the name? The name field will not be a unique constraint, however. Think

Avinash Nk

Your point is good. and it is not a piece of new knowledge for me. We can't predefine what the end-users needs.

Right?

Hilar Andikkadavath

Good to hear from you. We should able to predefine the end-users needs anyway. That is the role of a coder.

Avinash Nk

Thank you for the valuable advice. Have a nice day

相關帖文 回覆 瀏覽次數 活動
How can I display data from database in form view
query
頭像
0
9月 23
6258
Insert query in odoo 13 已解決
query
頭像
頭像
1
7月 20
5011
How can i write update query in a function? 已解決
query
頭像
頭像
頭像
頭像
3
1月 20
12712
ORM Relationship in Odoo 12
orm
頭像
0
9月 19
98
ParseError: "duplicate key value violates unique constraint "res_groups_name_uniq"?
query
頭像
0
12月 23
8122