Hello,

I want to search with AND operator in ODOO, but could not find the way to do it. Examples:

1. 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?