Odoo Help


Meaning of each advance filter conditions

on 8/28/13, 5:20 AM 3,280 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--

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

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

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: 3280 times
Last updated: 3/16/15, 8:10 AM