Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
3 Trả lời
6826 Lượt xem

Hello,

I am trying to figure out how to search a product by combining 2 attributes. 

I have a product A which has 2 variant types : brand (brandX and brandY) and color (black, white and blue) : total 6 variants.

I want to be able to search for product A with brandX AND color Black but instead Odoo is searching for product A with brandX OR color black. 

I tried adding +, AND, &, space, brand:brandX, and few other things but it's not working. Any way to achieve this?

Thanks!



Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

Search terms you apply to the same search (usually the same field) are combined with OR.

Example: Enter large, apply to Attributes.  Enter red, apply to Attributes.



Search terms you apply to different searches (usually different fields) are combined with AND.

Example: Enter large, apply to Attributes.  Enter stock, apply to Location.

 

To force Odoo to "OR" your different search terms together:

Use ADD A CONDITION under the Filters Menu beneath the search bar:



This results in two search terms on different fields being applied with OR:



To force Odoo to "AND" your same search terms together

Create two Custom Filters under Filters Menu beneath the search bar.  (Product Attributes is the field to search in your case);

This results in two search terms on the same field being applied with AND:

 

Note: Although the screenshots are from the Enterprise edition of version 9, this is how it works on the Community edition of version 8 and 9.

Ảnh đại diện
Huỷ bỏ
Tác giả

It works when I use the Custom filter options, thanks.

Câu trả lời hay nhất

I know my answer is late but it can be help

if you want to search by part of words , you can use % symbol between your inputs

e.g : search for product named "Iphone gold" , inter  : iph%go  in the search 

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

Tom,
if i am not wrong with your requirement then you can simply use this domain:

[('<product_field>', '=' product_id),('<brand_field>','=', 'brandX'),('<color_field>','=','black')]

you can use it in your search method and should resolve it!    

Hope it helps!

Ảnh đại diện
Huỷ bỏ
Tác giả

Thanks but this is complicated to use for my staff... I was looking for something more intuitive.

Bài viết liên quan Trả lời Lượt xem Hoạt động
1
thg 2 22
2601
1
thg 7 25
379
Search a message Đã xử lý
1
thg 2 25
1202
0
thg 9 23
2146
2
thg 6 23
3900