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:
  1. Name: Highlight based on LOB/Department Column
  2. Event: After Refresh
  3. Selection Type: Region
  4. Region: {select your report region}
  5. Condition: No Condition
  6. Action: Execute JavaScript code
  7. Fire On Page Load: True
  8. 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"});  }
}); 

  1. Selection Type: Region
  2. Region: {select your report region}

  • Result :


Note : You need to modify dynamic action JavaScript part td[headers="Column_Name"] according your report column alias.



Leave a Reply

Subscribe to Posts | Subscribe to Comments

Welcome to My Blog

Study Basics

Oracle APEX Oracle SQL Oracle PL/SQL

Popular Post

Blogger templates

Total Pageviews

Powered by Blogger.

Unordered List

Follow us on Facebook!

- Copyright © TechnicalBits -Robotic Notes- Powered by Blogger - Designed by Johanes Djogan -