How to Optimize Odoo Search Queries with AND Conditions

In products view we have lots of products with varying names. It is really needed to filter and search to get exactly what we want. By default, Odoo has an OR operator when we search for two different keywords for the same field.

In the products view, sometimes we face a huge type of product, each with unique and sometimes complex names. This makes it absolutely essential to have precise filtering and search capabilities to locate the exact items we need.By default, Odoo uses an ‘OR’ operator when searching for multiple keywords within the same field means that if you search for two keywords, Odoo will return products that contain either keyword, rather than both, leading to a flood of potentially irrelevant results and a frustrating search experience. Dont worry we have the solutions.

Implementing AND condition in Odoo for Better Filtering

In this blog post we’ll delve into a practical solution for refining your Odoo product searches. Specifically explore how to implement the AND operator in Odoo directly through the front-end interface to pinpoint the products with multiple specific attributes so for that First lets go to the products view.

Right here at the top of the product view you’ll find the search bar. Now, let’s input our desired keywords to start the search. For this example, we’ll use ‘apc’ and ‘ups’.

As you can I have given two keywords – ‘apc’ and ‘ups’. All I want is to get all product names with both ‘apc’ and ‘ups’. But Odoo gives me products with the ‘apc’ and products with ‘ups’ keywords.

Now let’s do it according to our requirement.

Click on the ‘Product’ to get a wizard.

From here, delete all the rules except the Name rule. And change Any on the top into All. By changing it into ‘All’ we are changing the operator from OR to AND. like this:

Click Confirm. You will get all the products with both keywords in it. Like this you can add different keywords and get products with all of them in it through this method.

This simple adjustment in your Odoo search queries can save your valuable time and reduce the frustration of filtering through irrelevant results. By implementing the AND operator, you can ensure that your product searches are accurate and efficient.

So this is all About the AND condition in Odoo If you experience any challenges or need further assistance with Odoo’s search functionality, feel free to contact Bassam Infotech for personalized support.