31,003
edits
Universal Search Filter Syntax: Difference between revisions
Jump to navigation
Jump to search
m
→Syntax of UFS
m (→Syntax of UFS) Tag: 2017 source edit |
m (→Syntax of UFS) Tag: 2017 source edit |
||
| Line 28: | Line 28: | ||
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, 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. | ||
| Line 39: | Line 39: | ||
(myfield:>=:123.45) | (myfield:>=:123.45) | ||
(t.mydatefield:>:'2024-01-01 10:00:00') | (t.mydatefield:>:'2024-01-01 10:00:00') | ||
(myfield:like:'asubstring') | |||
</syntaxhighlight> | </syntaxhighlight> | ||