Universal Search Filter Syntax: Difference between revisions

Universal Search Filter Syntax (view source)

11 bytes removed , 2 years ago

m

31,003

edits

@@ Line 25: / Line 25: @@
 = Syntax of UFS =
 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 operator can be =, <, >, <=, >=, !=, in, notin, like, notlike, 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. The use of the parenthesis are not allowed into the value, even into a quoted string.
+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.
 Then, you can combine any simple test using parenthesis and OR or AND to forge combined tests.