+

Addition (numeric)

Adds one value to another

Budgets.'Total invoiced/actual costs' +Budgets.'Remaining budget'

Concatenation (strings)

Appends strings

See Text constant for an example.

Personnel.'First name' + Personnel.Surname

-

Subtraction

Subtracts one value from another

Budgets.Budget -Budgets.'Total invoiced/actual costs'

*

Multiplication

Multiplies one value by another

Budgets.'% of budget category' * 0.95

/

Division

Divides one value by another

Budgets.'Remaining budget'/ 12

%

Modulo or remainder operator. This operator returns the remainder of a division.
Example
5 % 2 = 1

Orders.Workplace.'Surface area' % Orders.'Number of people'

=

Equals

Returns items that match the value following the equal sign

Orders.'User-defined status'.Code = "O1"

<

Less than

Returns items that are less than a specified value

Orders.'User-defined status'.Code < "O2"

>

Greater than

Returns items that are greater than a specified value

Orders.'User-defined status'.Code > "O1"

!=

Does not equal

Returns items that are not equal to a specified value

Orders.'User-defined status'.Code != "O1"

<=

Less than or equal

Returns items that are less than or equal to a specified value

Orders.'User-defined status'.Code<="O2"

>=

Greater than or equal

Returns items that are greater than or equal to a specified value

Orders.'User-defined status'.Code >= "O2"

and

Logical AND

Results in an expression that checks on both parameters

Orders.Property.'Property code' = "41008" and Orders.'Requested completion date' = currentDate()

or

Logical OR

Returns items for which one of the parameters is true

Orders.'Number of people' = 8 or Orders.'Number of people' = 9

not

Logical NOT

Returns items for which none of the parameters is true

not (Orders.'Number of people' = 8 or Orders.'Number of people' = 9)

If () then else

If then else

Returns items matching the query as 1 and other items as 0

( if (not( Orders.'Transferred to archive (Y/N)') )then (Orders.Number))