Authentication Options | Description | |
Comparison Operators: | ||
eq | Equal | companyname eq ‘Able Computing’ |
ne | Not Equal | companyname ne ‘Able Computing” |
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 |
Logical 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') |
Operator | Description | Example |
Arithmatic 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 | Example |
String Functions | |
contains | contains(CompanyName,'freds') |
endswith | endswith(CompanyName,'Futterkiste') |
startswith | startswith(CompanyName,'Alfr') |
length | length(CompanyName) eq 19 |
indexof | indexof(CompanyName,'lfreds') eq 1 |
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' |
Date Functions | |
year | year(BirthDate) eq 0 |
month | month(BirthDate) eq 12 |
day | day(StartTime) eq 8 |
hour | hour(StartTime) eq 1 |
minute | minute(StartTime) eq 0 |
second | second(StartTime) eq 0 |
fractionalseconds | second(StartTime) eq 0 |
date | date(StartTime) ne date(EndTime) |
time | time(StartTime) le StartOfDay |
totaloffsetminutes | totaloffsetminutes(StartTime) eq 60 |
now | StartTime ge now() |
mindatetime | StartTime eq mindatetime() |
maxdatetime | EndTime eq maxdatetime() |
Math Functions | |
round | round(Freight) eq 32 |
floor | floor(Freight) eq 32 |
ceiling | ceiling(Freight) eq 33 |
Type Functions | |
cast | cast(ShipCountry,Edm.String) |