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!

How to obtain the query for a faceted search

SmuckersDec 3 2019 — edited Dec 4 2019

I just created a new report using the faceted search capability of 19.2.  It's great -- my users will love it.  However, in my apps, I always provide the ability to export the report contents to Excel. My normal 'Go To' report type is an IR, and the APEXIR_XLSX_PKG available on GitHub is great for exporting those to Excel.  The underlying 'Excel export' code for that is xlsx_builder_pkg (which is a slightly modified version of Anton Scheffer's AS_XLSX package). The query2sheet function of that package would easily allow me to export a Faceted Search report to Excel... if I can derive the query programmatically.

For Interactive Reports, the APEX_IR.GET_REPORT function will retrieve the query for a given interactive report with bind variable info,  I can't find a comparable function for Faceted Search reports, but that would be ideal.  I'm certain that I can write PL/SQL that would generate the SQL and binds for this one report, but a more generic solution would be much better., I don't really want to re-invent the wheel for every Faceted Search report that I create.

Comments
Post Details
Added on Dec 3 2019
5 comments
2,137 views