Operator | Description | Exemple |
---|---|---|
Comparison Operators | ||
eq | Equal | City eq 'Redmond' |
ne | Not equal | City ne 'London' |
gt | Greater than | Price gt 20 |
ge | Greater than or equal | Price ge 10 |
lt | Less than | Price lt 20 |
le | Less than or equal | Price le 100 |
Logiacal Operators | ||
and | Logical and | Price le 200 and Price gt 3.5 |
or | Logical or | Price le 3.5 or Price gt 200 |
not | Logical negation | not endswith(Description,'milk') |
Arithmetic Operators | ||
add | Addition | Price add 5 gt 10 |
sub | Subtraction | Price sub 5 gt 10 |
mul | Multiplication | Price mul 2 gt 2000 |
div | Division | Price div 2 gt 4 |
mod | Modulo | Price mod 2 eq 0 |
Grouping Operators | ||
( ) | Precedence grouping | (Price sub 5) gt 10 |
Function | Exemple |
---|---|
String Functions | |
contains | contains(CompanyName,'freds') |
endswith | endswith(CompanyName,'Futterkiste') |
startswith | startswith(CompanyName,'Alfr') |
length | length(CompanyName) eq 19 |
substring | substring(CompanyName,1) eq 'lfreds Futterkiste' |
tolower | tolower(CompanyName) eq 'alfreds futterkiste' |
toupper | toupper(CompanyName) eq 'ALFREDS FUTTERKISTE' |
trim | trim(CompanyName) eq 'Alfreds Futterkiste' |
concat | concat(concat(City,', '), Country) eq 'Berlin, Germany' |
Attention: when setting the filter, make sure to not use extra spaces and that the operators and functions are in lower case.