I have enabled pagination for the Interactive Report in a custom apex application and max rows for each page is 15. There are a total of 47 matches(47 rows) to a search query. So that makes 4 pages of my IR. I want to store all those 47 results into a JS variable for some computation. Is there any JS code/package that I can use to get those 47 rows at once?
Discy Latest Questions
hi, working on a client requirement and need help, they want to create a Department wise IR which should contains multi level sums on Sal columns like (emp): in each Department JOB wise Total, after end of each department should show Department’s Total and in end of report it will show Grand Total. I used Control Beak on Department and then Job but it is showing only Job totals. may be I am doing wrong here OR any other feature it of for the same? be blessed, regards
I already set configuration of SMTP and I could send an email by the PL/SQL Code as below successfully, Declare l_body clob; l_body_html clob; begin l_body := 'To view the content of this message, please use an HTML enabled mail client.' || utl_tcp.crlf; apex_mail.send ( p_to => 'email@example.com', p_from => 'firstname.lastname@example.org', p_body => 'This is a test email', -- p_body_html => l_body_html, p_subj => 'test' ); apex_mail.push_queue(); end; But when I try to send an email from Interactive Report (Actions->Download->Email) is not working??? Please advise, Thanks