Maximo Variable and Constants

Below are list of few variables and constants that can be used in building expression for ur where clause.

:&date& -- Current date

:&datetime& -- Current date/time

:&username& -- Logged in user ( eg :ownerid=:&user&)

:&personid& -- Person ID of the logged in user ( eg :supervisor!=:&personid&)

:&appname& -- Application name 

:&mboname& -- Name of the current MBO

:&ownername& -- Name of the owner MBO ( eg :&owner&.po.$old_description like '%Turbin%')

&SYSDATE& -- For current time stamp

!NOT READY! -- To get the default value for the synonym from the synonym domain associated for the current attribute.

~null~ for null value searching in any resultsets