Want to search products with AND operator instead of OR operator

Question

Hello i want to search products with AND operators not with OR operator. i am using odoo v12
Example:
I want to search Table Top in first search i write Table, in next search i write top so it will not show Table Top only it will show the products with table and top also. thats why i want AND operator for search perfection.
Help in this matter will be appreciated.

Ray Carnes (ray) · Accepted Answer

To search for "table" *and *"top":
1. Enter your first search term as normal:
​
2. Enter your second search term as a Custom Filter:
​
This gives you the *AND *search:
​

sanu future learning AG · Answer

@Javier, do you have a solution to search with the operator AND without using the custom filter instead of the OR?

Javier García Fillol · Answer

the answer of Ray Carnes (ray) is good but it is too slow to workin in wharehouse
Exist any short cut to use "and" instead of "or" operator?
Example if you use enter button use a "or" operator, but if you press ctrl + enter instead to unify to same search using "or" change to new field using "and" operator

Це запитання позначене

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