Refresh reports w/ pagination Tweet
Refresh classic and IR, and keep pagination
(This is the version for APEX 4.*; you can find the version for APEX 5.* here: http://apex-plugin.com/oracle-apex-plugins/dynamic-action-plugin/refresh-reports-w%10-pagination_420.html )
When you want to refresh your Report (interactive or classic), but don't want to submit the entire page, you typically use Dynamic Action > Refresh.
This works for classic and interactive reports.
How do you use it?
Instead of using "Refresh" in your Dynamic Action, after you install the plugin all you have to do is to select Refresh report and keep pagination [Plug-in] as your true action and then select the affected region. And that's it!
If you have any questions, post a comment below or send me an email and I'll try to respond as soon as possible.
Classic report regions wouldn't refresh if the report had no rows at first and you just inserted the first row. This has now been fixed. Thanks to Ali Y for pointing out the bug.
Reports with static IDs wouldn't refresh. This has now been fixed.
Interactive Report, classic report, refresh, pagination
Do you have a question about this Plugin? Want to write a Review or Comment?
Reviews / Questions / Comments are e-mailed to the author of the Plug-in.
where application_id =:APP_ID
Let say, it is 123456.
var current_set = $("#DEPARTMENTS .uReportPagination .pagination span.fielddata").text().trim();
var first_record = current_set.substr(0,current_set.indexOf(' '));
3) Handle empty record set in region's "After Refresh" by condition:
$("#XXDL_DEPARTMENTS .apex-tabular-form-error-box").size() > 0
to just refresh the region.
works when 2nd record set becomes blank (departments or employees / delete or transfer).
Thanks for taking the effort to making this plugin, it saved me a lot of work figuring this one out myself.
I did however find a problem when you use the plugin after the number of rows changed, (in my case by using a delete) and the current page has no more records to show. (Apex will give you a warning (where the report should be), and give you the option to reset the pagination. ("Invalid set of rows requested, the source data of the report has been modified.")
I had this when using the plugin for a classic report, but I'm pretty sure you will have the same result in an interactive report.
If you are able to override the refresh, I'll be happy to rewrite the code for you, sometime next week.
Let me know at firstname.lastname@example.org.
|Powered by Sigsiu.NET|