Oracle APEX - report download Internal Server Error

0
votes

I have an interactive grid that displays over 250k records and has more than 30 columns. When I attempt to download the report in csv format, I get an Internal Server Error. How can I get around that? Is there a way to limit the number of records (I know that when there are fewer records it works fine)? Is there a way to automatically split report in two parts and download two separate files?

1
oracle-apexoracle-apex-19.2

1 Answers

0
votes

You can always add filters to your SQL Query, that way the end user downloads the data they really need.

For example: 1. Create some items like Select List.

  1. Enter the proper filter in your SQL Query, as follows: SQL Query including items page to filter data

  2. Include the items in Page Items to Submit.

  3. Create a Dynamic Action to refresh your IG when the end user selects a different value for the items