What I want to accomplish in Oracle APEX: I want to be able to use the faceted search with the ability to hide/show columns on the report, and then also be able to select records in the report so that I can manipulate them how I want to.
I can select the records with a classic report using JavaScript/PLSQL , or use the interactive report, but as far as I know you can't use a Interactive report with the faceted search. I'm fine with using the classic report, but I want to be able to hide/show columns (similarly to the action button).Action button on Interactive Report
How can I either:
Or where can I find a relevant resource to help me?
I tried changing the classic report to a interactive report, but then the faceted search says it's Invalid Faceted Search source section in the page designer
Faceted search is only possible out-of-the-box with Classic Reports or Cards region.
When you use the Create Page Wizard the only option is "Diplay as" Report or Card.
But you can try a more custom approach like this: https://blogs.oracle.com/apex/post/add-a-chart-to-your-faceted-search-page