Forum Stats

  • 3,750,345 Users
  • 2,250,159 Discussions
  • 7,866,944 Comments

Discussions

Conditional cell color on a pivot report (Interactive Report)

Riassuncao
Riassuncao Member Posts: 34 Red Ribbon
edited Jul 8, 2021 5:42PM in APEX Discussions

Hi guys, how are you doing?

We are using APEX 20.2 version.

We have an application here and there is a page on that, which uses pivot table based on an interactive report.

That interactive report has a static id value.

Depending on the cell value of pivot table, we must change font and background colors.

We have this code on the field "execute when page loads":

$("#FREQ_B tbody tr td").each(function(){

   if ($(this).text() == 'F') {

     $(this).css({"color":"red"});

     $(this).css({"font-weight":"Bold"});

     $(this).css({"background-color":"mistyrose"});    

   } else if ($(this).text() == ' ') {

     $(this).css({"background-color":"white"});  

   } else {

     $(this).css({"background-color":"#fafafa"});

   }   

});

$("#FREQ_M tbody tr td").each(function(){

   if ($(this).text() == 'F') {

     $(this).css({"color":"red"});

     $(this).css({"font-weight":"Bold"});

     $(this).css({"background-color":"mistyrose"});  

   } else if ($(this).text() == ' ') {

     $(this).css({"background-color":"white"});       

   } else {

     $(this).css({"background-color":"#fafafa"});       

   }

});

This code has been working fine until we've changed Apex version. Since then, this code seems to be incorrect.

Any ideas of what is going wrong?

Thanks in advance,

Robson