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] )