Universal Search Filter Syntax: Difference between revisions

Universal Search Filter Syntax (view source)

67 bytes added , 2 years ago

m

31,003

edits

@@ Line 29: / Line 29: @@
 * The first operator allows only the following characters: a to z, 0 to 9, _, - and .
-* The operator can be: =, <, >, <=, >=, !=, in, notin, like, notlike, isnull, isnotnull (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 quotes 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 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.