Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Conditional cell color on a pivot report (Interactive Report)

RiassuncaoJul 8 2021 — edited Jul 8 2021

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

Comments

Post Details

Added on Jul 8 2021
0 comments
809 views