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:
- User a interactive Report Instead of a classic report
- Use a Classic report with the same/similar Action button
- Or accomplish something similar?
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