Odoo Help


Use AND operator in search view

Antoine Morit
on 2/18/15, 4:59 PM 1,787 views

As a user,if I use standard search view, for exemple, for searching products containing box AND blue, and not box OR blue (this is default behavior). Is it possible to override the default behavior of search with multiple values for the same field ?

Possible duplicate: https://www.odoo.com/forum/help-1/question/how-to-use-and-or-operators-in-advanced-filters-1130

Stefan Rijnhart
on 2/19/15, 3:53 AM

It's not duplicate, my question is about standard search, especally on names, not Advanced. I gave an example for products but it is the same for customers. If I search for name "James" and if I add "Bond", I don't want more answers (OR operator) but a filter on answers already filtered with first query (AND operator)

Antoine Morit
on 2/19/15, 4:22 AM

michel Guénard

--michel Guénard--

| 5 5 8
--michel Guénard--

VP operations & finance Social entrepreneur Certified Public Accountant Past Chief internal auditor

michel Guénard
On 2/18/15, 7:20 PM

As far as I understand your question, the standard search view (V7) allows to search with the operator AND: you just need to create 2 successive filters the first one with products contains box and the second with products contains blue.

On 6/14/16, 1:24 AM

It's possible to change the filter to use all time AND and not OR? because for example when you have a lot of attributes on a product variant, you can't use the search way to select the field and then the value all time. This is very time eating and not user friendly.

Juan José Scarafía
On 2/19/15, 10:53 AM

Hi Antoine,

To make a search with AND, you have to search first a thing, and then, in Advance Search, you have to select the other word to search and click in Apply.

Here you can watch a tutorial explaining how the search box work: http://youtu.be/VmwmFlkUQ9o


Juan José - Ing ADHOC

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 2/18/15, 4:59 PM
Seen: 1787 times
Last updated: 6/14/16, 1:24 AM