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

Gerelateerde posts	Antwoorden	Weergaven
Search module for Odoo 9 search searching	0 nov. 16	3320
How do I modify search behavior to search all fields? search searching	2 mrt. 15	9063
How to create a module to add a 'general search field' for website users search searching cms	0 mrt. 15	4611
How do I filter a spreadsheet pivot to the current/previous month search	1 jul. 25	1462
Search a message Opgelost search	1 feb. 25	1821

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!