Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Add selected rows from multiple pages from the interactive report with pagination

SunilpandaJul 20 2015 — edited Jul 27 2015

Hi Team ,

I have a interactive report  with pagination. and a button to extract the selected rows for export in csv file.

My requirement is do extract all the selected rows from the report in a single Excel file. For example

If I am selecting 3 rows from page 1 and i got to next pagination and i select 2 and i go to next pagination and select 3 then when I click on the button extract it will be extract all 7. but now its only retrieving the page 3 , 3 rows details only.

I am using a dynamic action as below on click on the button.

var offIds = $("input[name='f01']:checked").map(function() {

    return this.value;

}).get().join("~");

vReportRegionId = $v('P80_' + $v('Download_EXTRACT') + '_REGIONID');

window.open('f?p=&APP_ID.:133:&USER_SESSION.:FLOW_EXCEL_OUTPUT_R' + vReportRegionId + ':&DEBUG.::P133_OFFERS_IDS:'+offIds,'_self','location=no,menubar=no,scrollbars=yes,toolbar=no,resizable=yes,top=0,left=0');

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 24 2015
Added on Jul 20 2015
4 comments
461 views