Skip to Content
This question has been flagged
searchattribute
3 Respostes
7418 Vistes
Avatar
Tom

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!



Avatar
Descartar
Avatar
Ray Carnes
Best 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:



This results in two search terms on different fields being applied with OR:



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

Create two Custom Filters under Filters Menu beneath the search bar.  (Product Attributes is the field to search in your case);

This results in two search terms on the same field being applied with AND:

 

Note: Although the screenshots are from the Enterprise edition of version 9, this is how it works on the Community edition of version 8 and 9.

Avatar
Descartar
Tom
Autor

It works when I use the Custom filter options, thanks.

Avatar
salah
Best 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 

Avatar
Descartar
Avatar
Pawan
Best 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!

Avatar
Descartar
Tom
Autor

Thanks but this is complicated to use for my staff... I was looking for something more intuitive.

Related Posts Respostes Vistes Activitat
[v14] Check if product has an attribute named "color" (qweb custom report) Solved
product search attribute
Avatar
1
de febr. 22
3173
How do I filter a spreadsheet pivot to the current/previous month
search
Avatar
Avatar
1
de jul. 25
1453
Search a message Solved
search
Avatar
Avatar
1
de febr. 25
1817
Disable Instant Search on /shop
search
Avatar
0
de set. 23
2722
User search operators
search
Avatar
Avatar
2
de juny 23
4830