Running on APEX version 18.2 and trying to find a way to be able to use the data in an Interactive Report.
I want to either get access to the data itself in the IR directly, or get the exact sql query and query the db using that. Preferrably I'd like to get the sql query. If possible to get the query it has then to include any filtering made by the user ie it has to be the latest query made.
I have seen suggestions on how to get the query on other sites but it seems this was for earlier APEX versions.
To me it seems this should be a simple thing and something provided already in the APEX api, but it probably isn't.
Does anybody have an idea on how to solve this?