Oracle Application Express (MOSC)

MOSC Banner

Classic report - get runtime query and filters

Is there a way to extract the query, including applied filters and sort columns during runtime from a Classic Report? What I am seeking is similar functionality that is provided by the APEX_IR package to get an interactive report runtime query and filters.

I am using Apex 20.2.

I have a classic report on page 1 with a column that links to another page (page 2) which includes detailed information about the record.  On page 2, I wish to provide record navigation (first, previous, next, last record) so that users do not have to return back to page 1 to select the next record.  I have used the APEX_IR package previously to provide this functionality when an Interactive report is used on page 1.  I cannot use an Interactive report as I am experimenting with the faceted search and this functionality appears to be limited to Classic reports only.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center