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!

Powiązane posty	Odpowiedzi	Widoki
[v14] Check if product has an attribute named "color" (qweb custom report) Rozwiązane product search attribute	1 lut 22	3254
How do I filter a spreadsheet pivot to the current/previous month search	1 lip 25	1568
Search a message Rozwiązane search	1 lut 25	1894
Disable Instant Search on /shop search	0 wrz 23	2800
User search operators search	2 cze 23	4960

To pytanie dostało ostrzeżenie

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

Podoba Ci się ta dyskusja? Dołącz do niej!