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
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
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
|Asked: 8/28/13, 5:20 AM|
|Seen: 2188 times|
|Last updated: 3/16/15, 8:10 AM|