Press "Enter" to skip to content

Oracle Apex: Auto Refresh Report After a Specified Interval

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

Have you found the answer to your question? If not, you can discuss it with me in the comments section below or join my Q&A community OrclQA.com for developers and ask your question. It is FREE.

Vinish Kapoor

Follow

Hi, I am a full stack developer and writing about development. I document everything I learn and help thousands of people. foxinfotech.in is created, written, and maintained by me; it is built on WordPress, and hosted by Bluehost. Connect with me on Facebook, Twitter, GitHub, and get notifications for new posts.

guest
0 Comments
Inline Feedbacks
View all comments