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	Odpovědi	Zobrazení
[v14] Check if product has an attribute named "color" (qweb custom report) Vyřešeno product search attribute	1 úno 22	2719
How do I filter a spreadsheet pivot to the current/previous month search	1 čvc 25	588
Search a message Vyřešeno search	1 úno 25	1296
Disable Instant Search on /shop search	0 zář 23	2245
User search operators search	2 čvn 23	4077

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!