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!

Highlight a row in classic report based on condition

Newbie_apex07Dec 2 2013 — edited Dec 9 2013

HI all Gurus

Using Apex 4.1.1 oracle 11g linux oc4j

I want to highlight a row where #column_value#='Y' to grey  keep others as normal report settings.

I have a simple sql query

SELECT PK_ID,

  FIRST_NAME,

  LAST_NAME,

  INITIAL_REG_DATE,

  MAIL_DATE,

  BEGIN_DATE,

  END_DATE,

  END_DATE-BEGIN_DATE as "#days",

  BEGIN_STATUS,

  END_STATUS, 

  COMMENTS,

DELETE_FLAG,

case when  DELETE_FLAG='Y' then 'GREY' else '#f0f0f0' end  DELETE_FLAG ,

INITIAL_REG_DATE+(END_DATE-BEGIN_DATE) "New Reg end date"

FROM SOR_TRACKING_DEL

where pk2_id =:P216_Detail

order by mail_Date desc

I created a Dynamic action

which will fir on on load , BIND on this classic report

$("input[name=f29]").each(function(){ 

var lThis=$(this); 

if(lThis.is("Y")){ 

  lThis.parents("tr:eq(0)").children("td").css({"background-color":"GREY"}); 

} else { 

  lThis.parents("tr:eq(0)").children("td").css({"background-color":"#f0f0f0"}); 

}); 

But this is not changing color as expected..

Kindly help me !

Thanks

This post has been answered by Newbie_apex07 on Dec 3 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 6 2014
Added on Dec 2 2013
10 comments
4,845 views