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%’
Variables for Dynamic Queries in Conditional Expressions
:&USER& does not exists. It may be :&USERNAME& which is the same as USER.USERID
how can I calculate differnce between two dates in hours ( that is in numeric ) and compare with numeric value in conditional expression?
I am trying to modify a communication template so the FROM address is of the user currently signed on. How can I get this accomplished? What variable should I use?
Same problem
Have you find a solution?
What about using SYSDATE in conditional expressions of ESCALATIONS