Hello,
I want to search with AND operator in ODOO, but could not find the way to do it. Examples:
- Product search - I want to find all the products that contains in name words table AND garden.
This should returns me results like:
Outdoor Table for the garden
Garden set - table plus 4 chairs
This should not returns results like:
Wooden chair and table
Garden lighting
2. Customer search - I want to find records that contains in name words big AND company
This should returns me results for customers, how have in names both words, for exampe:
- Big distribution company AG
- Big daddy service company Ltd.
This should not returns the results for records, that contains only 1 of the words. For example:
- Real estateds company
- Big boy key services ltd.
Please let me know - is there a way to do this type of smart search.
P.S. is there a way also to have instant search - results to be shown dinamicly after each key in search meny?

Have you seen Ray's answer here: https://www.odoo.com/forum/help-1/how-to-add-multiple-domain-conditions-in-odoo-combine-and-with-or-161616#answer-289585