Universal Search Filter Syntax: Difference between revisions

Jump to navigation Jump to search
m
Tag: 2017 source edit
Tag: 2017 source edit
Line 32: Line 32:


* If the value is a string, you must add simple quotes. If value is a date, it must use the international format (YYYY-MM-DD or YYYY-MM-DD HH:MM:SS) in the timezone of the server and be quotes too.
* If the value is a string, you must add simple quotes. If value is a date, it must use the international format (YYYY-MM-DD or YYYY-MM-DD HH:MM:SS) in the timezone of the server and be quotes too.
When using the in or notin operator, the character must be used to separate each possible value, the char can be used inside the value.
When using the in or notin operator, the character "," must be used to separate each possible value, the character "," can be used inside the value.


Then, you can combine any simple test using '''parenthesis''' and '''OR''' or '''AND''' to forge combined tests.
Then, you can combine any simple test using '''parenthesis''' and '''OR''' or '''AND''' to forge combined tests.

Navigation menu