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”

Surprising there isn’t one for current attribute. That would really come in handy for what I’m trying to do at this moment.

In regards to conditional expressions, that is. Not for queries.

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 ??????