Odoo Help


How do I control how search terms are combined? How do I "AND" two terms for the same field together (Odoo uses "OR"), like a product with attribute X AND attribute Y?

on 8/15/16, 11:23 PM 647 views


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?


Ray Carnes
On 8/16/16, 5:59 PM

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.

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

on 8/17/16, 5:06 AM
On 8/16/16, 8:11 AM

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!

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

on 8/17/16, 5:07 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 8/15/16, 11:23 PM
Seen: 647 times
Last updated: 8/16/16, 9:42 PM