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 First/last page links for IR

First/last page links for IR

8
Categories: Dynamic Action Plugin
Author: Ana Miloš

Add first/last page links to Interactive Reports

This is version for APEX 5.*

Version for APEX 4.* can be found here http://apex-plugin.com/oracle-apex-plugins/dynamic-action-plugin/first%10last-page-links-for-ir_371.html

 

Info

This plugin simply adds the image links to the first and last page of your Interactive Report.
You can replace the images I provided with your own images, as long as you don't change the filenames (first_page.gif, last_page.gif).

 

How to use it

First, you need to set the pagination of your Interactive Report to "Rows X to Y of Z". (The plugin requires the number of rows in order to calculate the first/last page links).


Then you create a dynamic action, your true action is Add first/last page links to IR, set it to fire After Refresh of your Interactive Report region, and check the "Fire on page load" attribute. 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.  

 

13.12.2015.:  fixed bug regarding top and bottom pagination (thanks to people who pointed it out!) 


 


Keywords

Oracle APEX Plugin
Company:
Date added: 10.8.2015
Views: 6289
Votes: 22
Reviews: 35
Min. APEX Version:
5.0
Share on Facebook
Digg! Share on Digg
Save This Page
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 sandy harrison
on September 27, 2018
I'm new to apex and one of the first thing that i find a little annoying is that on a report with many records, you can't simply go to the last page of the report and back to the first page. This plugin would come in handy except that i cannot get it to work. I have version 5.1, ran the script in the db as user apex_050100, set pagination to x to y of z, created a dynamic action with true action as you said, set to fire after refresh. The check Fire on Page Load is tricky. Where is this to be found on the page? Also i have icons (.gif) a little different than yours that i copied in the image folder. In version, i had to add images to the shared components. Do i have to do this with version 5 and if so, how do i do it?
0 
by sandy harrison
on September 27, 2018
I'm new to apex and one of the first thing that i find a little annoying is that on a report with many records, you can't simply go to the last page of the report and back to the first page. This plugin would come in handy except that i cannot get it to work. I have version 5.1, ran the script in the db as user apex_050100, set pagination to x to y of z, created a dynamic action with true action as you said, set to fire after refresh. The check Fire on Page Load is tricky. Where is this to be found on the page? Also i have icons (.gif) a little different than yours that i copied in the image folder. In version, i had to add images to the shared components. Do i have to do this with version 5 and if so, how do i do it?
6 
mrs
by sandy harrison
on September 26, 2018
I'm new to apex, just fiddling around. I've just installed your plug-in. My version is 5.1.4.I can't seem to get this to work. I've created a dynamic action with a true action as you mentioned and set it to fire after refresh. It is the Fire on page load that I can't find. Is it in the attribute section of the IR? Also, what about the icons first/last page? Do they need to be physically be copied to my image folder?
6 
mrs
by sandy harrison
on September 26, 2018
I'm new to apex, just fiddling around. I've just installed your plug-in. My version is 5.1.4.I can't seem to get this to work. I've created a dynamic action with a true action as you mentioned and set it to fire after refresh. It is the Fire on page load that I can't find. Is it in the attribute section of the IR? Also, what about the icons first/last page? Do they need to be physically be copied to my image folder?
6 
mrs
by sandy harrison
on September 26, 2018
I'm new to apex, just fiddling around. I've just installed your plug-in. My version is 5.1.4.I can't seem to get this to work. I've created a dynamic action with a true action as you mentioned and set it to fire after refresh. It is the Fire on page load that I can't find. Is it in the attribute section of the IR? Also, what about the icons first/last page? Do they need to be physically be copied to my image folder?
0 
by sandy harrison
on September 26, 2018
I'm new to apex, just fiddling around. I've just installed your plug-in. My version is 5.1.4.I can't seem to get this to work. I've created a dynamic action with a true action as you mentioned and set it to fire after refresh. It is the Fire on page load that I can't find. Is it in the attribute section of the IR? Also, what about the icons first/last page? Do they need to be physically be copied to my image folder?
8 
Another way to fix
by jbleach
on November 7, 2017
Of coarse I didn't look at these comments before debugging I could have save myself some time. I made the same correction as below except I used this. Maybe the find is more flexible though.
"rows_per_page = $("#"+affectedRegionId+" .a-IRR-selectList")[1].value;"
8 
Another way to fix
by jbleach
on November 7, 2017
Of coarse I didn't look at these comments before debugging I could have save myself some time. I made the same correction as below except I used this. Maybe the find is more flexible though.
rows_per_page = $("#"+affectedRegionId+" .a-IRR-selectList")[1].value;
8 
Another way to fix
by jbleach
on November 7, 2017
Of coarse I didn't look at these comments before debugging I could have save myself some time. I made the same correction as below except I used this. Maybe the find is more flexible though.
rows_per_page = $("#"+affectedRegionId+" .a-IRR-selectList")[1].value;
8 
Another way to fix
by jbleach
on November 7, 2017
Of coarse I didn't look at these comments before debugging I could have save myself some time. I made the same correction as below except I used this. Maybe the find is more flexible though.

rows_per_page = $("#"+affectedRegionId+" .a-IRR-selectList")[1].value;
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.