Dynamic expression

If you have checked the "Expression" box, the value can be a Dynamic expression.

Examples

Assets purchased in the year:

Criterion: purchaseDate
Operator: Greater than or equal to
Value: {startOfYear}

Purchase request issued by the user:

Criterion: askedBy.code
Operator: equal
Value: {user.code}

Work orders for which the cost of the services exceeds the cost of labor by 20%:

Criterion: actServiceCost
Operator: Strictly greater than
Value: {bean.actLabourCost} * 1,2

 

Script

You can select the "Script" operator to define the highlighting condition in an elaborate way.

The following key words are used in the script:

• bean refers to the entity displayed on the line,
• value is the value of the selected criterion.

The last line of the script is the Boolean Expression determining the highlighting.

Example

Work orders for which the incurred cost is 20% greater than the estimated cost for labor and operations:

Criterion: actLabourCost
Script: ((value > bean.expLabourCost * 1.2) && (bean.actMiscCost > bean.expMiscCost * 1.2));