Operators

Expressions can be combined using operators. Each operator as a precedence priority. Here is the list of those expression’s priority.

• primary
• unary
• power
• multiplicative
• additive
• relational
• logical

Logical

These operators can do some logical comparison between other expressions:

or, ||

and, &&

true or false and true

The and operator has more prioroty than the or, thus in the example above, false and true is evaluated first.

Relational

=, ==, !=, <>

<, <=, >, >=

[Total] < 2000

Additive

+, -

[Total] + [Tax] > 3000

Multiplicative

*, /, %

[Price] * [Quantity] == [Total]

Bitwise

& (bitwise and), | (bitwise or), ^(bitwise xor), << (left shift), >>(right shift)

[Field1] >> [Field2] > 5

Unary

!, not, -, ~ (bitwise not)

not true

Primary

values

(, )

2 * ( [Field1] + [Field2] )