Odoo Help


Meaning of each advance filter conditions

on 8/28/13, 5:20 AM 2,428 views


I would like to know the difference between each condition used in the advance filter. Can someone help me? When should we use a particular option? at what scenario? for which fields ?

To make it clear, I would like to know different between these options used in the conditions:

contains, doesn't contain, equals, is not equal, is set, is not set, less than, greater than, less than or equal, greater than or equal



Kevin McMenamin

--Kevin McMenamin--
Solnet Solutions Limited
| 5 2 6
Auckland, New Zealand
--Kevin McMenamin--
Kevin McMenamin
On 8/29/13, 6:14 AM

an extra point to note with advanced search filters. if you have multiple conditions in the same advanced filter they are OR statements. if you need AND statements, do multiple advanced filters within the same view


Francesco OpenCode

--Francesco OpenCode--
Francesco OpenCode
| 5 7 9
Grottaglie, Italy
--Francesco OpenCode--

Italian Odoo (OpenERP) Modules Developer LINKEDIN: http://www.linkedin.com/in/francescoapruzzese

Francesco OpenCode
On 8/28/13, 6:33 AM

contains Search the filter keyword in the field content example: Search 'erp' in 'openerp'

not contains Search the string not contains the keyword example: 'openerp' non contain 'sap'

equals Search the some string example: 'erp' equals 'erp' or 'ERP' or 'Erp'

is not equal Search the string not equals to keywork example 'OpenERP' not equals 'SAP'

is set Search the records when the field has a value (it's not important the value itself, it's important it exists)

is not set Search the records without a value

less than, greater than Search the records where the field has a value lesser (or greater) then your keyword value

less than or equal, greater than or equal Like the other but search the record with a value equal to keyword, too

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 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

0 follower(s)


Asked: 8/28/13, 5:20 AM
Seen: 2428 times
Last updated: 3/16/15, 8:10 AM