IF EXPRESSION

[1539601747]

HOW CAN I USE IF EXPRESSION FOR A COLUMN THAT WITH MORE THAN TWO CASES? FOR EXAMPLE    case1: 0->NEW case2 : 1->FINISHED  case3: 2->DELETED 

[jgust]

What you are looking for is the ternary operator.  The format is :

(expression) ? value if true : value if false[/code]

Here is an example of a nested ternary operator:

$P{PM_M_CAMP_ID}.isEmpty() ?            "Campuses: All Campuses"    : $P{PM_M_CAMP_ID}.contains( "* All Campuses" ) ?            "Campuses: All Campuses"    : $P{PM_M_CAMP_ID}.size() > 19 ?              "Campuses: " + $V{CampusListLast3CharFIRST} + ".." + $V{CampusListLast3CharLAST}    : $P{PM_M_CAMP_ID}.size() < 20 ?              "Campuses: " + $V{CampusListLast3CharALL}.join(", ", $P{PM_M_CAMP_ID}).replaceAll($P{psEnter Organization ID},"")    : ""[/code]