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!

Setting IR grid row colours from resultset column value

General DogsbodyApr 17 2020 — edited Apr 21 2020

Hello, although i have been exposed to APEX for a number of years i have been unable to dedicate much time to developing any applications - now i have had to develop something in a hurry.

What would in principle seem to be straight forward - display a grid of database data with different text colours - has turned into a nightmare.

I have googled for hours to get a simple answer to 'how to set row colour' in Apex 5.1  , bear in mind i am a dinosaur and am more at home coding in Motorola 68000 assembler than web page theory so i need an easy answer.

To date I have an 'Interactive Report' with a dynamic action firing on page load that runs the following javascript :

$(document).ready(function() {

     console.log("Page Load DA")

    $("td:nth-child(10)").each(function() {

       

       $(this).closest('tr').find('td').css({"color":$(this).text()});

       

    });  

    }); 

Firstly, I hate hard coding - that '10' should be a column identifier but we can worry about that later.

The big issue is that only the first 40 rows get 'coloured' , it would appear that the 'page load' event only fires after 40 rows have been fetched - setting dynamic actions on 'Scroll' , 'Change' have no effect.

Please help, or at least point me at somewhere there is a guide to web programming for machine code programmers.

Thanks

Gordon

 

    

<tr role="row" data-id="39" class="a-GV-row is-readonly is-selected" aria-selected="true"><td role="gridcell" tabindex="-1" class="a-GV-cell u-tS" style="color: rgb(0, 128, 0);"><a href="javascript:apex.navigation.dialog('f?p=102:42:7119090969007::NO:RP,42:P42_MATNR:11050004\u0026p_dialog_cs=87UiZ8kXOCqjuKJwQscGnIrHE5fvlPlirpVI2Lf1ccEBZ_5BRS2LwGgW8Tykt6-bLJurt-mOEpW6gJQZbkkUBQ',{title:'Where used',height:'auto',width:'720',maxWidth:'960',modal:true,dialog:null},'t-Dialog-page--standard '+'',apex.jQuery('#R11320144965692813'));" tabindex="-1">11050004</a></td><td role="gridcell" tabindex="0" class="a-GV-cell u-tS" style="color: rgb(0, 128, 0);" aria-labelledby="C11303886746627540_HDR">AZA10380BZE01-S-NDE </td><td role="gridcell" tabindex="-1" class="a-GV-cell u-tS" style="color: rgb(0, 128, 0);">125mm SMSS23-AX CBa/ZC-EPR(NON D/E)*SEAL</td><td role="gridcell" tabindex="-1" class="a-GV-cell u-tE" style="color: rgb(0, 128, 0);">4</td><td role="gridcell" tabindex="-1" class="a-GV-cell u-tE" style="color: rgb(0, 128, 0);">1</td><td role="gridcell" tabindex="-1" class="a-GV-cell u-tE" style="color: rgb(0, 128, 0);">2</td><td role="gridcell" tabindex="-1" class="a-GV-cell u-tE" style="color: rgb(0, 128, 0);">1</td><td role="gridcell" tabindex="-1" class="a-GV-cell u-tE" style="color: rgb(0, 128, 0);">1</td><td role="gridcell" tabindex="-1" class="a-GV-cell u-tS" style="color: rgb(0, 128, 0);">NO</td><td role="gridcell" tabindex="-1" class="a-GV-cell u-tS" style="color: rgb(0, 128, 0);">GREEN</td></tr>

This post has been answered by General Dogsbody on Apr 20 2020
Jump to Answer
Comments
Post Details
Added on Apr 17 2020
12 comments
1,698 views