Dynamic query variables in Maximo

Here is a list of variables you can use in Maximo for queries. Thanks to Alexander for the tip!

  • :yes – true
  • :no – false
  • :&date& – current date
  • :&datetime& – current date/time
  • :&user& – logged in user
  • :&personid& – Person ID of the logged in
  • :&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 from the database of the attribute

Did You Know...

As Maximo Experts, we have developed several add-on products for Maximo that mobilize the work force, simplifies assignments, provides ad-hoc reporting capabilities and facilitates the seamless integration of Service Requests into Maximo.

Check out our products by clicking on the following links: EZMaxMobile, EZMaxPlanner and EZMaxRequest.

Find Out More

3 thoughts on “Dynamic query variables in Maximo

  1. If using any of these variables on the More Search Fields to build SQL Where do you put a = in front or let it use the wildcard LIKE? Neither seems to work??? How can I use the variables on a WHERE Clause to build a Saved Query I can use on a Result Set?

    For example LEAD = :&user& OR LEAD LIKE ‘%:&user&%’ etc etc ??????

Leave a Reply