Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
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!
Example: Enter large, apply to Attributes. Enter red, apply to Attributes.
Example: Enter large, apply to Attributes. Enter stock, apply to Location.
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:
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.
It works when I use the Custom filter options, thanks.
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
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!
Thanks but this is complicated to use for my staff... I was looking for something more intuitive.
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
