Advanced Interactive Reporting - Expert Oracle Application Express - page 552

Figure 13-32. Page Views by Interactive Report
The alternate default report was last used 22 hours ago, and not by me, so I will be keeping it
around.
APEX_UTIL functions
APEX_UTIL is a public package that provides access to lots of great utilities. Several of these are
specifically for interactive reports.
IR_CLEAR and IR_RESET
IR CLEAR is the programmatic way to clear the report settings for a report, essentially a CIR for the page
and saved report that you specify. IR RESET is the programmatic way to reset a report, essentially an RIR
for the page and saved report that you specify. As private reports have no alias, they cannot be used with
these procedures. The syntax for each is
APEX UTIL.IR CLEAR (
p page id IN NUMBER,
p report alias IN VARCHAR2 DEFAULT NULL );
APEX UTIL.IR RESET (
p page id IN NUMBER,
p report alias IN VARCHAR2 DEFAULT NULL );
To clear the primary report, you can either pass the report alias of the primary report or leave the
p report alias null. Recall that you can find and update the report aliases for saved interactive reports
using either Saved Reports from the page definition or the Saved Reports available within
Administration. The report alias can also be queried from the APEX APPLICATION PAGE IR RPT view. If you
have not used the APEX Views yet, that might be the best tip of all. They are accessible from within the
Application Builder under Utilities and you can also query them from within a schema that is associated
with Application Express.
Both these procedures are used within the example for IR FILTER .