August 8, 2012

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


4 comments:

  1. :&USER& does not exists. It may be :&USERNAME& which is the same as USER.USERID

    ReplyDelete
  2. how can I calculate differnce between two dates in hours ( that is in numeric ) and compare with numeric value in conditional expression?

    ReplyDelete
  3. 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?

    ReplyDelete