31,003
edits
Universal Search Filter Syntax: Difference between revisions
Jump to navigation
Jump to search
m
→Syntax of UFS
Tag: 2017 source edit |
m (→Syntax of UFS) Tag: 2017 source edit |
||
| 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. | 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 allow only this 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 used the international format 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. | 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. | ||
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. | ||
Example of simple tests: | Example of simple tests: | ||