Odoo Help


This community 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.


Use AND operator in search view

Antoine Morit
on 2/18/15, 4:59 PM 937 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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)


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