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

Relaterede indlæg	Besvarelser	Visninger
Search module for Odoo 9 search searching	0 nov. 16	4181
How do I modify search behavior to search all fields? search searching	2 mar. 15	10091
How to create a module to add a 'general search field' for website users search searching cms	0 mar. 15	5548
How do I filter a spreadsheet pivot to the current/previous month search	1 jul. 25	3221
Search a message Løst search	1 feb. 25	3188

Dette spørgsmål er blevet anmeldt

Kan du lide at diskutere? Læs ikke bare med, deltag aktivt i debatten!