Plugin: Defer Report Load on Tab focus
I am happy to announce my new Dynamic Action plugin: “Defer Report Load on Tab focus”. Get it ap apex.world!
This Dynamic Action plugin is meant to be used for slow reports that run under a tab container. Put another way, it’s for reports that are not visible right away and perhaps may not be unless the user clicks on the tab.
The plugin assists in deferring the load of an IR or Classic report until the tab gets focus. In reality, the report does run, but it should use a “trigger” item set to ‘N’ the first time it loads. Then, the DA will switch the trigger item to Y when the tab receives focus and refresh report and load the data.
Demo App: here
I made a quick video to show how it’s used.
Nice work !!!.
Will it work for IG reports as well?
Hi Jorge ,
I tried the plugin in my apex environment .
Db version – 18.104.22.168.0 , apex – 20.1
Getting this error while running . Can you please help?
Error in PLSQL code raised during plug-in processing.
Contact your application administrator.
Technical Info (only visible for developers)
ora_sqlerrm: ORA-06550: line 4, column 55: PLS-00201: identifier 'JMR_DEFER_REPORT_LOAD_PLUGIN.RENDER' must be declared ORA-06550: line 4, column 1: PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1445
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_200100", line 513
ORA-06512: at "APEX_200100.WWV_FLOW_DYNAMIC_EXEC", line 1539
ORA-06512: at "APEX_200100.WWV_FLOW_PLUGIN", line 1494
wwv_flow_plugin_api.g_dynamic_action_render_result := jmr_defer_report_load_plugin.render (p_dynamic_action => wwv_flow_plugin_api.g_dynamic_action,p_plugin => wwv_flow_plugin_api.g_plugin );end;
Thanks for trying the plugin.
You need to compile the plugin package https://github.com/rimblas/APEX-refresh-on-tab-focus/tree/master/plsql
You get better performance when the plugin code is precompiled in a package.