Universal Search Filter Syntax: Difference between revisions

Universal Search Filter Syntax (view source)

76 bytes added , 2 years ago

m

31,003

edits

@@ Line 27: / Line 27: @@
 A simple test in UFS syntax is forged this way: Open parenthesis, then the first operand that is the field, then :, then the operator, then :, then the second operand that is the value, then the closing parenthesis.
-* The first operator allow only this characters: a to z, 0 to 9, _, - and .
+* 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, isnull, isnotnull and nothing else.
-* If the value is a string, you must add simple quotes. If value is a date, it must used the international format 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.