search with AND operator

Question

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 cu

IC LOGISTICS OOD · Accepted Answer

Hello, I have actuall found the solution. Should use % in search filter. For example gar%table returns all results with GAR and TAB in name, including Garden Table

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,
Please refer to the example below.
Go to Sales → Products → Products     Click Filters dropdown     Click Add Custom Filter     Set up filters like this:         First filter: Name → contains → "table"         Click Add a condition         Second filter: Name → contains → "garden"         Click Apply   image [1]

Hope it helps

[1] /web/image/93133408-df4df05c/image.png?access_token=0744ee5e-92cc-45c5-a00e-096131b9e38f

Powiązane posty	Odpowiedzi	Widoki
Search module for Odoo 9 search searching	0 lis 16	4072
How do I modify search behavior to search all fields? search searching	2 mar 15	9993
How to create a module to add a 'general search field' for website users search searching cms	0 mar 15	5406
How do I filter a spreadsheet pivot to the current/previous month search	1 lip 25	2842
Search a message Rozwiązane search	1 lut 25	2858

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!