Variables for Dynamic Queries in Conditional Expressions

Conditional Expressions can be used in TPAE applications in several ways. One powerful feature of Conditional Expressions is the capability of creating dynamic queries using substitution variables. Here is the complete list of variables available in Maximo.

• :YES – True
• :NO – False
• :&DATE& – Current date
• :&DATETIME& – Current date/time
• :&USER& – Logged in user (or &USERNAME&)
• :&PERSONID& – Person ID of the logged in user
• :&APPNAME& – Application name
• :&MBONAME& – Name of the current business object
• :&OWNERNAME& – Name of the owner business object
• :[relationshipname].[attrname] â€“ Value of an attribute of a related business object of the current 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
• :$OLD_[attrname]  â€“ The initial value of the attribute

Sample Expressions

Here is a small set of examples that can help to understand how those variables can be used.

• :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%'

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