31,003
edits
Universal Search Filter Syntax: Difference between revisions
Jump to navigation
Jump to search
m
→Syntax of USF
m (→Syntax of USF) Tag: 2017 source edit |
m (→Syntax of USF) Tag: 2017 source edit |
||
| Line 33: | Line 33: | ||
* The operator can be: =, <, >, <=, >=, !=, in, notin, like, notlike, is, isnot (and nothing else). | * The operator can be: =, <, >, <=, >=, !=, in, notin, like, notlike, is, isnot (and nothing else). | ||
* 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 | * If the value is a string, you must add simple quotes. If value is a date, it must use the international format into simple quotes ('YYYY-MM-DD' or 'YYYY-MM-DD HH:MM:SS') in the timezone of the server. | ||
When using the in or notin operator, the character "," must be used to separate each possible value, the character "," can't be used inside the value. When using the operator "is" or "isnot", the only allowed value is "null". | When using the "in" or "notin" operator, the character "," must be used to separate each possible value, the character "," can't be used inside the value. When using the operator "is" or "isnot", the only allowed value is "null". | ||
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. | ||