Posted on Thursday, January 3, 2013 Highlight IR row based on APP_USER Category APEX Tips and Tricks Here is how you can highlight interactive report rows if column value is same as login user name. I did get idea for this article from this OTN forum post.First create interactive report. In this example rows where manager name equals APP_USER value are highlighted.I have used following query joining EMP and DEPT tables for interactive report:SELECT e1.empno ,e1.ename ,e1.job ,e2.ename AS mgr -- Dynamic action use this column alias ,e1.hiredate ,e1.sal ,e1.comm ,d.dname ,d.loc FROM emp e1 LEFT JOIN emp e2 ON e1.mgr = e2.empno JOIN dept d ON e1.deptno = d.deptno Create dynamic action:Name: Highlight based on APP_USEREvent: After RefreshSelection Type: RegionRegion: {select your report region}Condition: No ConditionAction: Execute JavaScript codeFire On Page Load: TrueCode:this.affectedElements.find('table.apexir_WORKSHEET_DATA td[headers="MGR"]').each(function(i){ var lThis=$(this); if(lThis.text()=="&APP_USER."){ lThis.parent().children().css({"background-color":"#55A955"}); } }); Selection Type: RegionRegion: {select your report region}Note! You need modify dynamic action JavaScript part td[headers="MGR"] according your report column alias.See working example.When you loging to example application use username BLAKE, JONES or KING to see highlight in action.