Hello Apex Community.
First time post. I've been following the solution below to show a chart at the top of a page with faceted search, in addition to the classic report linked to the faceted search itself.
https://blogs.oracle.com/apex/post/add-a-chart-to-your-faceted-search-page
The issue we're having is that the solution provided using apex_region.open_query_context and apex_exec.next_row seems to be creating a table in memory with a subset of data set, then passing this filtered data set to the chart query.
This works for small datasets but makes the application stall when using large data sets.
Is there a way to pass on the filters in the faceted search to another query? I cannot find an Apex package to query the filters selected by the user. apex_region.open_query_context opens a cursor but does not provide information about the filters selected.
If you have any other ideas on how to resolve this, please also share.
Thank you!