Logical
AND
Description: Returns TRUE if all specified conditions evaluate to TRUE.
Syntax: condition AND condition
Example:
FILTER "Orders"."Value" > 100 AND "Orders"."Country" = 'DE';
NOT
Description: Negates a logical expression and returns the opposite boolean value.
Syntax: NOT ( condition )
Example:
FILTER NOT( "Orders"."Country" = 'DE' );
OR
Description: Returns TRUE if at least one of the specified conditions evaluates to TRUE.
Syntax: condition OR condition
Example:
FILTER "Orders"."Country" = 'DE' OR "Orders"."Country" = 'US';