CODEWITHSUNDEEP
oracle-apexoracle-apex-5.1
GMan1973
GMan1973

Reputation: 319

APEX changing row colors in an IG

I am following an example I found on-line as since I found it on the internet I know it must be correct. I am trying to search for a specific value in an IG and when it is found the line/row is highlighted with red text, Below it the logic I followed and screen shots. Please let me know what I am missing. He is using an employee example and I using my car dealership example. Thank you !

"Here's another approach that works great:
 For an IR with this query:
 select EMPNO,      ENAME,      JOB,      MGR,      HIREDATE,      SAL,      COMM,      DEPTNO,      
    OFFSITE
 from EMP
 Define for the column JOB the following Static ID: MANAGER_STATIC
 Then create a DA After Refresh on Region where On True Execute the following javascript with Fire 
on Page Load=ON:
this.affectedElements.find('td[headers="MANAGER_STATIC"]').each(function(i) {
var lThis = $(this);
if (lThis.text() == "MANAGER") {
lThis.parent().children().css({
"background-color": "#C0C0C0"
});
}
});
 And every row that has the value of MANAGER will be highlighted and this will respect pagination.

enter image description here

enter image description here

Upvotes: 0

Views: 3244

Answers (1)

Aaron
Aaron

Reputation: 214

That Example appears to be for an Interactive Report, but you appear to be using an Interactive Grid.

The easiest way to do this (without coding) is to run the report and use the Actions Button to define Highlighting. E.G.

enter image description here

Fill out form similar to this (Change column selection and value to your requirement): enter image description here

Afterwards, using the Action Button again to Report->Save the report so it saves the report for All Users.

Upvotes: 1

Related Questions