Oracle Apex: Auto Refresh Report After a Specified Interval

Oracle Apex: Auto Refresh Report After a Specified Interval

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.

To auto-refresh, a report in Oracle Apex, use the setInterval() method to specify the interval in milliseconds and use jQuery to refresh the report region. The following are the steps:

1. Specify a Static ID for the interactive or classic report

In Oracle Apex, click on the report region, then in the property palette, scroll down to the Advanced section and specify a static id in the field, for example, projects_report.

2. Add jQuery code to the page to Auto-Refresh the Report

Click on the page, go to the JavaScript section, and add the following jQuery code to the Execute when the page loads text area. 1000 milliseconds is equal to 1 second, so specify the interval as needed.

// this will auto-refresh the projects report every 10 seconds.
setInterval("jQuery('#projects_report').trigger('apexrefresh');", 10000);

Related tutorials

This Post Has 2 Comments

  1. Anil December 3, 2020

    Hi Vinish, I want to add progress bar for long running queries in oracle apex. So need your help to setup progress bar.

    Thanks
    Anil

    1. Bernhard Fischer-Wasels February 23, 2021

      look @ apex.world.... - there is a plugin for a progress bar

Comments are closed.