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)

Automation Scripts within Conditional Expressions to control business logic | Maximo

We are very well aware of these Attribute Launch Point, Object Launch Point, Action Launch Point but today we are going to discuss Custom Condition Launch Point.

Sometimes complex business logic involving conditions that need to be evaluated and cannot be covered in simple conditional expression, therefore we need to evaluate conditions within automation script to take the result into conditional expression.

Its a simple 3 steps process:
1. An automation script to handle all business logic
2. Conditional Expression to have this automation in it.
3. use this conditional expression wherever you want.

1. for instance:
lets create a Custom Condition Launch Point ISWONEW
script name is CHECKIFWONEW
Object: WORKORDER
Launchpoint Type: CUSTOMCONDITION
script:

evalresult = onadd

# evalresult = False or True
evalresult is an implicit variable in Custom Conditional Launch Point

2. Conditional Expression; create new
Name: ISWONEW , name as created a launchpoint in step 1
Expression: CHECKIFWONEW:ISWONEW (scriptname:launchpoint)
Class: com.ibm.tivoli.maximo.script.ScriptCustomCondition


reference: https://expertinmaximo.wordpress.com/2016/08/26/automation-script-for-conditional-expressions/

Conditional expression syntax | IBM Maximo

You enter conditional expressions using a syntax similar to Structured Query Language (SQL) with some additional variables.

When you create a conditional expression, use a colon (:) to define a variable. The colon is used to avoid ambiguity when you create expressions that relate the current record to a different, specific record.

You can have subselect in an expression,

exists (select 1 from workorder where wonum=:wonum).

The first wonum is the wonum attribute on the work order object. At run time, the second wonum is replaced with the value of the wonum attribute for the current record.

Modify Label using Conditional Expression | IBM Maximo

1. signature option new or existing (e.g. READ)
2. In Advance:
Security Group: EveryOne
Condition: our condition (e.g. :status = 'APPR')
Property: label (if condition true)

value "status is approved"

Property(if false) label (if condition false)

value "Status is not approved"
 

Dynamic Query Variables can use in Query or Conditional Expressions – IBM Maximo

a list of variables we can use in Maximo for queries or we can use in Conditional Expressions:

:yes – true

:no – false

:&datetime& – current date/time

:&date& – current date

:&personid& – person ID of the logged in

:&user& – logged in user

:&ownername& – name of the owner 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

:&appname& – application name

:&mboname& – name of the current business object

:<relationshipname>.<attrname> – value of an attribute of a related business object of the current business object

:$old_<attrname> – the initial value from the database of the attribute

How to Hide Elements based on Condition in BIRT in 5 Steps - IBM Maximo