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!

İlgili Gönderiler	Cevaplar	Görünümler
[v14] Check if product has an attribute named "color" (qweb custom report) Çözüldü product search attribute	1 Şub 22	2719
How do I filter a spreadsheet pivot to the current/previous month search	1 Tem 25	588
Search a message Çözüldü search	1 Şub 25	1296
Disable Instant Search on /shop search	0 Eyl 23	2245
User search operators search	2 Haz 23	4077

Bu soru işaretlendi

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!