unable to use AND operator in place of OR operator in Inventory V12

Question

I have seen on internet how to replace AND with OR operator while searching in omnibar of inventory in Odoo 12.
when ever I type two values to be search together i.e. "blue"<space>"box", it searches with BlueORbox. whereas I want it to search it BlueANDbox.
please help me in the rules here.
​

Mital Vaghani · Answer

You can add custom filter one by one from filters as shown in below given screenshot.

Hassan Hanif · Answer

here is the screenshot attached
https://ibb.co/sJXmXN7

Niyas Raphy (Walnut IT) · Answer

Hi,
You can use this third party module for the same. This module will help you to use And conditions in the omnibar search, regarding the usage, look at the module documentation/index file :   Use AND conditions on omnibar search [1]

Thanks

[1] https://www.odoo.com/apps/modules/11.0/web_search_with_and/

faOtools · Answer

When yoy enter criteria in omnibox, the OR operator would be always applied, when filters my be applied with a separator.
For your goal use the advanced search: Filter > Add custom filter.
There insert a first search condition > press apply. Then apply the second one. They would be applied with the AND operator. You may assign as many of custom searches as you like with the AND operator.

This question has been flagged

Enjoying the discussion? Don't just read, join in!