Hello,
We have an APEX page - with 2 Interactive reports (1 called CSV DATA).
2 date pickers - start date and end date.
2 buttons - run report and downloadtocsv
There is a hidden page item with type - SQL Query and the sql query is;
select region_id
from apex_application_page_regions
where application_id = :app_id
and page_id = :app_page_id
and region_name = 'CSV DATA'
The downloadtocsv button has an action of "Redirect to URL" with a url of https://........./f?p=&APP_ID.:&APP_PAGE_ID.:&SESSION.:IR[R&89_CSV_REGION.]_CSV:ClearCache:
The CSV DATA interactive report runs a SQL query.
Now when the user clicks on downloadtocsv, the CSV DATA SQL should run and get exported to csv but instead it gives an HTTP 400 error.
*** This worked in APEX 5.1.3
Any help would be appreciated. For this use case we cannot use the built-in download to csv option.
Regards,
David