Predicate
BETWEEN
Description: Checks whether a value falls within a specified inclusive range.
Syntax: expr BETWEEN lower AND upper
Example:
FILTER "Orders"."Value" BETWEEN 100 AND 500;
Comparison operators
Description: Operators such as =
Syntax: expr = value | expr != value | expr < value | expr <= value | expr > value | expr >= value
Example:
FILTER "Orders"."Status" = 'Closed' AND "Orders"."Value" >= 0;
IN
Description: Checks whether a value matches any value within a specified list.
Syntax: expr IN ( value1 , value2 [ , ... ] )
Example:
FILTER "Orders"."CompanyCode" IN ('001','002');
IS NULL
Description: Checks whether a value is NULL.
Syntax: expr IS NULL
Example:
FILTER "Orders"."DeliveryDate" IS NULL;
LIKE
Description: Performs pattern matching on strings using wildcard characters.
Syntax: expr LIKE 'pattern'
Example:
FILTER "Customers"."Name" LIKE 'Acme%';