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.
Hi I'm using odoo 10 community and I have a question regarding the search bar:
When I'm searching a specific variation in my inventory and I'm using the search bar, odoo automatically add attribute search with an "OR" opérator. is it possible to search several attributes with an "AND" operator. I don't want to use a custom filter since it would be very long to make a search.
thanks for your help!
hello you can point your resarch to a function called in your model and test it with boolean field
there is an example
('type', '=', 'remove'),
for holiday in holidays_maladie:
Use AND conditions on omnibar search
When searching for records on same field Odoo joins multiple queries with OR. For example:
- Perform a search for customer "John" on field Name
- Odoo displays customers containing "John"
- Search for "Smith" on same field Name
- Odoo displays customers containing "John" OR "Smith"
With this module installed you can press Shift key before searching for "Smith" and Odoo finds customers containing "John" AND "Smith"