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?

Question

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!

Ray Carnes · Accepted 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:

salah · 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

Pawan · 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!

Related Posts	Odgovori	Prikazi
[v14] Check if product has an attribute named "color" (qweb custom report) Solved product search attribute	1 feb. 22	3169
How do I filter a spreadsheet pivot to the current/previous month search	1 jul. 25	1452
Search a message Solved search	1 feb. 25	1816
Disable Instant Search on /shop search	0 sep. 23	2720
User search operators search	2 jun. 23	4828

This question has been flagged

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

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

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

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

Enjoying the discussion? Don't just read, join in!