Complex Conditions

Table -16 Complex Conditions

Complex Conditions Syntax Logic

Complex Conditions	Syntax	Logic
And	`(` condition `AND` condition `)` `(` condition `&` condition)	Compares two conditions. Returns true if all conditions are true. Example: `(1 > 4 AND 5 > 2)` Returns false
Not	`NOT (` condition `)` `! (` condition `)`	Negates the result by reversing the result of the condition. Example: `Not (1 > 4)` Returns true
Or	`(` condition `OR` condition `)` `(` condition `\|` condition `)`	Compares two conditions. Returns true if any of the conditions are true. Example: `(1 > 4 OR 5 > 2)` Returns true

And

( condition AND condition )

( condition & condition)

Compares two conditions. Returns true if all conditions are true.

Example:

(1 > 4 AND 5 > 2)

Returns false

Not

NOT ( condition )

! ( condition )

Negates the result by reversing the result of the condition.

Example:

Not (1 > 4)

Returns true

( condition OR condition )

( condition | condition )

Compares two conditions. Returns true if any of the conditions are true.

Example:

(1 > 4 OR 5 > 2)

Returns true

Complex conditions And, Or, and Not are fully supported. However, they must be surrounded by parentheses.

Valid example:

If ( ([A] > [B] and [A] > 1000), [A], [B])

Invalid example:

If ( [A] > [B] and [A] > 1000, [A], [B])