Skip to Main Content

Monday, December 6, 2010

Filter interactive report by clicking report cell

APEX and jQuery

Here is how you can filter interactive report by single mouse click.

If you are using APEX 3.x, load jQuery library in page template header or page HTML header.
Place to page HTML header:

<script type="text/javascript">
$(function(){
 $('.apexir_WORKSHEET_DATA td').live('click',function(){
  $('#apexir_SEARCH').val($(this).text());
  gReport.search('SEARCH');
 });
});
</script>

Pagination

Comments

  • Confiteor 26 Apr 2012
    Thank you. Solution is working very good.