Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
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?
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?
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.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 8/15/16, 11:23 PM|
|Seen: 325 times|
|Last updated: 8/16/16, 9:42 PM|