Skip to Content
This question has been flagged
searchattribute
3 Replies
7542 Views
Avatar
Tom

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!



Avatar
Discard
Avatar
Ray Carnes
Best Answer

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.

Avatar
Discard
Tom
Author

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

Avatar
salah
Best Answer

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 

Avatar
Discard
Avatar
Pawan
Best Answer

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!

Avatar
Discard
Tom
Author

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

Related Posts Replies Views Activity
[v14] Check if product has an attribute named "color" (qweb custom report) Solved
product search attribute
Avatar
1
Feb 22
3263
How do I filter a spreadsheet pivot to the current/previous month
search
Avatar
Avatar
1
Jul 25
1595
Search a message Solved
search
Avatar
Avatar
1
Feb 25
1901
Disable Instant Search on /shop
search
Avatar
0
Sep 23
2805
User search operators
search
Avatar
Avatar
2
Jun 23
4975