Apex: Highlight IR row based on Column value

Posted by : Akshay Patil Friday, 10 July 2015

Consider below IR report:

I want to highlight only those rows whose LOB’s value is ERP.

Create dynamic action:

Name: Highlight based on LOB/Department Column
Event: After Refresh
Selection Type: Region
Region: {select your report region}
Condition: No Condition
Action: Execute JavaScript code
Fire On Page Load: True
Code:

this.affectedElements.find('table.apexir_WORKSHEET_DATA td[headers="DEPARTMENT_LOB"]').each(function(i){

var lThis=$(this);

if(lThis.text()=="ERP"){

  lThis.parent().children().css({"background-color":"#C0C0C0"});

  lThis.parent().children().css({"color":"#CC0000"});

}

});   var lThis=$(this); if(lThis.text()=="ERP"){  lThis.parent().children().css({"background-color":"#C0C0C0"});   lThis.parent().children().css({"color":"#CC0000"});  }
});

Selection Type: Region
Region: {select your report region}