APEX-PLUGIN.COM

..the apex plugin directory

an initiative of

Add your APEX Plugin info

Describe your Plugin’s features. You can upload the Plugin’s code and documentation, or, alternatively, submit the URLs to your Website, GitHup Repository or Blog.

You are here:
Follow us on Twitter
Dynamic Action Plugin Refresh reports w/ pagination

Refresh reports w/ pagination

8
Categories: Dynamic Action Plugin
Author: Ana Miloš

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  )  

 

 Info 

 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 fine, but it resets the pagination of the report and you end up back on page one after each refresh.
This can be quite annoying for a variety of reasons so I ended up creating a simple plugin which refreshes both interactive and classic report, but at the same time doesn't reset the pagination.

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!

 

Questions/comments/bugs

If you have any questions, post a comment below or send me an email and I'll try to respond as soon as possible. 

 

Update

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.

 

Update2

Reports with static IDs wouldn't refresh. This has now been fixed.


Keywords
Interactive Report, classic report, refresh, pagination

Oracle APEX Plugin
Company:
Date added: 20.12.2013
Views: 20215
Votes: 5
Reviews: 13
Min. APEX Version:
4.0
Share on Facebook
Digg! Share on Digg
Save This Page
Link to:
Download
download apex plugin
If something is not correct please report it here: Report Listing
Do you have a question about this Plugin? Want to write a Review or Comment?
Login first.
Reviews / Questions / Comments are e-mailed to the author of the Plug-in.
0 
by Greg
on October 27, 2017
Hi, I would really like this feature to work but it raises this error can you assist?

thanks Greg

refreshReport.js:16 Uncaught TypeError: Cannot read property 'replace' of undefined
at refreshReport (refreshReport.js:16)
at Object.javascriptFunction (f?p=117:163:3977587299524::::::3263)
at Object.da.doAction (desktop.min.js?v=5.0.4.00.12:17)
at Object.da.doActions (desktop.min.js?v=5.0.4.00.12:17)
at lWaitCallback (desktop.min.js?v=5.0.4.00.12:17)
at Object.da.resume (desktop.min.js?v=5.0.4.00.12:17)
at Object._success [as callback] (desktop.min.js?v=5.0.4.00.12:18)
at _success (desktop.min.js?v=5.0.4.00.12:9)
at Object.apex.event.trigger.lOptions.success (desktop.min.js?v=5.0.4.00.12:9)
at j (jquery-2.1.3.min.js?v=5.0.4.00.12:2)
refreshReport @ refreshReport.js:16
javascriptFunction @ f?p=117:163:3977587299524::::::3263
da.doAction @ desktop.min.js?v=5.0.4.00.12:17
da.doActions @ desktop.min.js?v=5.0.4.00.12:17
lWaitCallback @ desktop.min.js?v=5.0.4.00.12:17
da.resume @ desktop.min.js?v=5.0.4.00.12:17
_success @ desktop.min.js?v=5.0.4.00.12:18
_success @ desktop.min.js?v=5.0.4.00.12:9
apex.event.trigger.lOptions.success @ desktop.min.js?v=5.0.4.00.12:9
j @ jquery-2.1.3.min.js?v=5.0.4.00.12:2
fireWith @ jquery-2.1.3.min.js?v=5.0.4.00.12:2
x @ jquery-2.1.3.min.js?v=5.0.4.00.12:4
(anonymous) @ jquery-2.1.3.min.js?v=5.0.4.00.12:4
send @ jquery-2.1.3.min.js?v=5.0.4.00.12:4
ajax @ jquery-2.1.3.min.js?v=5.0.4.00.12:4
_call @ desktop.min.js?v=5.0.4.00.12:9
callOrQueue @ desktop.min.js?v=5.0.4.00.12:9
server.plugin @ desktop.min.js?v=5.0.4.00.12:9
da.executePlSqlCode @ desktop.min.js?v=5.0.4.00.12:18
da.doAction @ desktop.min.js?v=5.0.4.00.12:17
da.doActions @ desktop.min.js?v=5.0.4.00.12:17
(anonymous) @ desktop.min.js?v=5.0.4.00.12:17
each @ jquery-2.1.3.min.js?v=5.0.4.00.12:2
each @ jquery-2.1.3.min.js?v=5.0.4.00.12:2
da.actions @ desktop.min.js?v=5.0.4.00.12:17
(anonymous) @ desktop.min.js?v=5.0.4.00.12:17
dispatch @ jquery-2.1.3.min.js?v=5.0.4.00.12:3
r.handle @ jquery-2.1.3.min.js?v=5.0.4.00.12:3
trigger @ jquery-2.1.3.min.js?v=5.0.4.00.12:3
e.event.trigger @ jquery-migrate-1.2.1.min.js?v=5.0.4.00.12:2
(anonymous) @ jquery-2.1.3.min.js?v=5.0.4.00.12:3
each @ jquery-2.1.3.min.js?v=5.0.4.00.12:2
each @ jquery-2.1.3.min.js?v=5.0.4.00.12:2
trigger @ jquery-2.1.3.min.js?v=5.0.4.00.12:3
event.trigger @ desktop.min.js?v=5.0.4.00.12:8
customEvent @ f?p=117:163:3977587299524::::::73
close @ VM10178:1
lOptions.close @ desktop.min.js?v=5.0.4.00.12:7
_trigger @ desktop.min.js?v=5.0.4.00.12:24
(anonymous) @ desktop.min.js?v=5.0.4.00.12:25
(anonymous) @ desktop.min.js?v=5.0.4.00.12:24
dequeue @ jquery-2.1.3.min.js?v=5.0.4.00.12:3
(anonymous) @ jquery-2.1.3.min.js?v=5.0.4.00.12:3
each @ jquery-2.1.3.min.js?v=5.0.4.00.12:2
each @ jquery-2.1.3.min.js?v=5.0.4.00.12:2
queue @ jquery-2.1.3.min.js?v=5.0.4.00.12:3
e.Widget.(anonymous function) @ desktop.min.js?v=5.0.4.00.12:24
close @ desktop.min.js?v=5.0.4.00.12:25
(anonymous) @ desktop.min.js?v=5.0.4.00.12:24
(anonymous) @ desktop.min.js?v=5.0.4.00.12:24
each @ jquery-2.1.3.min.js?v=5.0.4.00.12:2
each @ jquery-2.1.3.min.js?v=5.0.4.00.12:2
e.fn.(anonymous function) @ desktop.min.js?v=5.0.4.00.12:24
closeFunction @ desktop.min.js?v=5.0.4.00.12:7
(anonymous) @ desktop.min.js?v=5.0.4.00.12:7
dispatch @ jquery-2.1.3.min.js?v=5.0.4.00.12:3
r.handle @ jquery-2.1.3.min.js?v=5.0.4.00.12:3
trigger @ jquery-2.1.3.min.js?v=5.0.4.00.12:3
e.event.trigger @ jquery-migrate-1.2.1.min.js?v=5.0.4.00.12:2
(anonymous) @ jquery-2.1.3.min.js?v=5.0.4.00.12:3
each @ jquery-2.1.3.min.js?v=5.0.4.00.12:2
each @ jquery-2.1.3.min.js?v=5.0.4.00.12:2
trigger @ jquery-2.1.3.min.js?v=5.0.4.00.12:3
navigation.dialog.fireCloseHandler @ VM10190 desktop.min.js?v=5.0.4.00.12:7
navigation.dialog.close @ VM10190 desktop.min.js?v=5.0.4.00.12:7
javascriptFunction @ VM10194 f?p=117:222:3977587299524::NO:422956::&cs=3LDxOGjJdolvbi6n63N5DSkkPtdc&p_dialog_cs=ihj5-eQMDdrrLhJzqfUomu8IuP4:267
da.doAction @ VM10190 desktop.min.js?v=5.0.4.00.12:17
da.doActions @ VM10190 desktop.min.js?v=5.0.4.00.12:17
lWaitCallback @ VM10190 desktop.min.js?v=5.0.4.00.12:17
da.resume @ VM10190 desktop.min.js?v=5.0.4.00.12:17
_success @ VM10190 desktop.min.js?v=5.0.4.00.12:18
_success @ VM10190 desktop.min.js?v=5.0.4.00.12:9
apex.event.trigger.lOptions.success @ VM10190 desktop.min.js?v=5.0.4.00.12:9
j @ VM10189 jquery-2.1.3.min.js?v=5.0.4.00.12:2
fireWith @ VM10189 jquery-2.1.3.min.js?v=5.0.4.00.12:2
x @ VM10189 jquery-2.1.3.min.js?v=5.0.4.00.12:4
(anonymous) @ VM10189 jquery-2.1.3.min.js?v=5.0.4.00.12:4
send @ VM10189 jquery-2.1.3.min.js?v=5.0.4.00.12:4
ajax @ VM10189 jquery-2.1.3.min.js?v=5.0.4.00.12:4
_call @ VM10190 desktop.min.js?v=5.0.4.00.12:9
callOrQueue @ VM10190 desktop.min.js?v=5.0.4.00.12:9
server.plugin @ VM10190 desktop.min.js?v=5.0.4.00.12:9
da.executePlSqlCode @ VM10190 desktop.min.js?v=5.0.4.00.12:18
da.doAction @ VM10190 desktop.min.js?v=5.0.4.00.12:17
da.doActions @ VM10190 desktop.min.js?v=5.0.4.00.12:17
lWaitCallback @ VM10190 desktop.min.js?v=5.0.4.00.12:17
da.resume @ VM10190 desktop.min.js?v=5.0.4.00.12:17
_success @ VM10190 desktop.min.js?v=5.0.4.00.12:18
_success @ VM10190 desktop.min.js?v=5.0.4.00.12:9
apex.event.trigger.lOptions.success @ VM10190 desktop.min.js?v=5.0.4.00.12:9
j @ VM10189 jquery-2.1.3.min.js?v=5.0.4.00.12:2
fireWith @ VM10189 jquery-2.1.3.min.js?v=5.0.4.00.12:2
x @ VM10189 jquery-2.1.3.min.js?v=5.0.4.00.12:4
(anonymous) @ VM10189 jquery-2.1.3.min.js?v=5.0.4.00.12:4
send @ VM10189 jquery-2.1.3.min.js?v=5.0.4.00.12:4
ajax @ VM10189 jquery-2.1.3.min.js?v=5.0.4.00.12:4
_call @ VM10190 desktop.min.js?v=5.0.4.00.12:9
callOrQueue @ VM10190 desktop.min.js?v=5.0.4.00.12:9
server.plugin @ VM10190 desktop.min.js?v=5.0.4.00.12:9
da.executePlSqlCode @ VM10190 desktop.min.js?v=5.0.4.00.12:18
da.doAction @ VM10190 desktop.min.js?v=5.0.4.00.12:17
da.doActions @ VM10190 desktop.min.js?v=5.0.4.00.12:17
(anonymous) @ VM10190 desktop.min.js?v=5.0.4.00.12:17
each @ VM10189 jquery-2.1.3.min.js?v=5.0.4.00.12:2
each @ VM10189 jquery-2.1.3.min.js?v=5.0.4.00.12:2
da.actions @ VM10190 desktop.min.js?v=5.0.4.00.12:17
(anonymous) @ VM10190 desktop.min.js?v=5.0.4.00.12:17
dispatch @ VM10189 jquery-2.1.3.min.js?v=5.0.4.00.12:3
r.handle @ VM10189 jquery-2.1.3.min.js?v=5.0.4.00.12:3
f?p=117:163:3977587299524::::::3182
6 
Issue on refresh
by Greg
on October 27, 2017
Hi , I was very pleased to see this plug in, but on install I got no data found. Still,m it was available but the hjava consoled reports this error and there is no refresh

refreshReport.js:16 Uncaught TypeError: Cannot read property 'replace' of undefined



It would be great to get this working can you assist?

Grezepp
6 
Error on refresh
by Greg
on October 27, 2017
Hi , I was very pleased to see this plug in, but on install I got no data found. Still,m it was available but the hjava consoled reports this error and there is no refresh

refreshReport.js:16 Uncaught TypeError: Cannot read property 'replace' of undefined



It would be great to get this working can you assist?

Grezepp
0 
Error on refresh
by Greg
on October 27, 2017
Hi , I was very pleased to see this plug in, but on install I got no data found. Still,m it was available but the hjava consoled reports this error and there is no refresh

refreshReport.js:16 Uncaught TypeError: Cannot read property 'replace' of undefined



It would be great to get this working can you assist?

Grezepp
0 
Error on refresh
by Greg
on October 27, 2017
Hi , I was very pleased to see this plug in, but on install I got no data found. Still,m it was available but the hjava consoled reports this error and there is no refresh

refreshReport.js:16 Uncaught TypeError: Cannot read property 'replace' of undefined



It would be great to get this working can you assist?

Grezepp
0 
Error on refresh
by Greg
on October 27, 2017
Hi , I was very pleased to see this plug in, but on install I got no data found. Still,m it was available but the hjava consoled reports this error and there is no refresh

refreshReport.js:16 Uncaught TypeError: Cannot read property 'replace' of undefined
at refreshReport (refreshReport.js:16)
at Object.javascriptFunction (f?p=117:163:3977587299524::::::3263)
at Object.da.doAction (VM9994 desktop.min.js?v=5.0.4.00.12:17)
at Object.da.doActions (VM9994 desktop.min.js?v=5.0.4.00.12:17)
at lWaitCallback (VM9994 desktop.min.js?v=5.0.4.00.12:17)
at Object.da.resume (VM9994 desktop.min.js?v=5.0.4.00.12:17)
at Object._success [as callback] (VM9994 desktop.min.js?v=5.0.4.00.12:18)
at _success (VM9994 desktop.min.js?v=5.0.4.00.12:9)
at Object.apex.event.trigger.lOptions.success (VM9994 desktop.min.js?v=5.0.4.00.12:9)
at j (VM9993 jquery-2.1.3.min.js?v=5.0.4.00.12:2)


It would be great to get this working can you assist?

Grezepp
0 
Error on refresh
by Greg
on October 27, 2017
Hi , I was very pleased to see this plug in, but on install I got no data found. Still,m it was available but the hjava consoled reports this error and there is no refresh

refreshReport.js:16 Uncaught TypeError: Cannot read property 'replace' of undefined
at refreshReport (refreshReport.js:16)
at Object.javascriptFunction (f?p=117:163:3977587299524::::::3263)
at Object.da.doAction (VM9994 desktop.min.js?v=5.0.4.00.12:17)
at Object.da.doActions (VM9994 desktop.min.js?v=5.0.4.00.12:17)
at lWaitCallback (VM9994 desktop.min.js?v=5.0.4.00.12:17)
at Object.da.resume (VM9994 desktop.min.js?v=5.0.4.00.12:17)
at Object._success [as callback] (VM9994 desktop.min.js?v=5.0.4.00.12:18)
at _success (VM9994 desktop.min.js?v=5.0.4.00.12:9)
at Object.apex.event.trigger.lOptions.success (VM9994 desktop.min.js?v=5.0.4.00.12:9)
at j (VM9993 jquery-2.1.3.min.js?v=5.0.4.00.12:2)


It would be great to get this working can you assist?

Grezepp
August 10, 2015
The Entry has been updated in the meantime!
0 
by Ana Miloš
on July 27, 2015
Added new version for APEX 5. Link in description.
Powered by Sigsiu.NET RSS Feeds

Disclaimer: The APEX Plugins on this site are not supported by Oracle Support Services.

If you have a question about a Plugin or need support: Login and select the plugin detail page. At the bottom you can enter your Question / Review / Remark.
Your message will be sent to the author of the plugin.