Implicit Variable of Domain Synonym List in Relationship Where Clause - SQL | Maximo

Another way in the SQL condition while creating Relationships in Maximo:

get all synonym values of CLOSE,CAN from work order status

 :&synonymlist&_wostatus[CLOSE,CAN]

is equivalent to

SELECT VALUE FROM SYNONYMDOMAIN WHERE DOMAINID = 'WOSTATUS' AND MAXVALUE IN ( 'APPR')

Usage:

Let's make a relationship and enter this condition within a where clause;

Other useful bind variables are here:

&USERNAME&, &APPNAME& and other special bind variables you can use (ibm.com)