31,003
edits
Universal Search Filter Syntax: Difference between revisions
Jump to navigation
Jump to search
m
→Syntax of USF
Tags: Mobile edit Mobile web edit |
m (→Syntax of USF) Tag: 2017 source edit |
||
| Line 31: | Line 31: | ||
* 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 and be | * 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 quoted too. | ||
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". | ||