IF
Description
IF evaluates a list of static conditions and replaces itself with the query for the first static condition that is true.
Syntax
IF static_condition THEN expression [ ELSE IF condition THEN calculation ]* [ ELSE calculation ] END
In contrast to STATIC CASE WHEN, an IF query does not require an ELSE. Not specifying an ELSE in an IF results in an empty PQL query if none of the static conditions are met.
NULL handling
If a static condition evaluates to NULL, it is treated as if it was false.
Examples
[1] In this example, we use | ||||||||||||||||||||
| ||||||||||||||||||||
|