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!

Post Terkait	Replies	Tampilan
[v14] Check if product has an attribute named "color" (qweb custom report) Diselesaikan product search attribute	1 Feb 22	2623
How do I filter a spreadsheet pivot to the current/previous month search	1 Jul 25	398
Search a message Diselesaikan search	1 Feb 25	1213
Disable Instant Search on /shop search	0 Sep 23	2158
User search operators search	2 Jun 23	3919

Pertanyaan ini telah diberikan tanda

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

Menikmati diskusi? Jangan hanya membaca, ikuti!