Conditional expression syntax | IBM Maximo

You enter conditional expressions using a syntax similar to Structured Query Language (SQL) with some additional variables.

When you create a conditional expression, use a colon (:) to define a variable. The colon is used to avoid ambiguity when you create expressions that relate the current record to a different, specific record.

You can have subselect in an expression,

exists (select 1 from workorder where wonum=:wonum).

The first wonum is the wonum attribute on the work order object. At run time, the second wonum is replaced with the value of the wonum attribute for the current record.

Dynamic Query Variables can use in Query or Conditional Expressions – IBM Maximo

a list of variables we can use in Maximo for queries or we can use in Conditional Expressions:

:yes – true

:no – false

:&datetime& – current date/time

:&date& – current date

:&personid& – person ID of the logged in

:&user& – logged in user

:&ownername& – name of the owner business object

:&owner&.<attrname> – value of an attribute of the owner business object

:&owner&.<relationshipname>.<attrname> – value of an attribute of the related business object of the owner business object

:&appname& – application name

:&mboname& – name of the current business object

:<relationshipname>.<attrname> – value of an attribute of a related business object of the current business object

:$old_<attrname> – the initial value from the database of the attribute