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

In Maximo Saved Query

Suppose we want to filter records of logged in users only

Create a saved query and paste below mentioned in where clause:

(reportedby = :USER)

Or it can be used in Conditional expressions

    :wostatus='APPR'

    :type='EM'

    :ownerid=:&user&

    :supervisor!=:&personid&

    :asset.assettype = 'IT' and :&personid&=:owner

    :reportby=:&personid&

    :assetspec.classstructureid = 1221

    :po.poline.receivedqty=0

    :&owner&.jobplan.priority>:&owner&.priority

    :&owner&.po.$old_description like '%Turbin%'

Reference: http://www-01.ibm.com/support/docview.wss?uid=swg21614036

Reference: http://maximodev.blogspot.com/2012/08/variables-dynamic-queries-conditional-expressions.html