Odoo Help

Welcome!

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.

0

Meaning of each advance filter conditions

By
Vivekrajan
on 8/28/13, 5:20 AM 2,290 views

Hi,

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

Thanks.

1

Kevin McMenamin

--Kevin McMenamin--
804
| 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

1

Francesco OpenCode

--Francesco OpenCode--
3608
| 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 community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

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