33.4 CLEAR_REPORT Procedure Signature 1
This procedure clears report filter settings to the developer defined default settings using the report ID.
Note:
The use of this procedure in a page rendering process causes report download issues (CSV, HTML, Email, and so on). When a user downloads the report, the interactive grid reloads the page with download format in the REQUEST value. Any interactive grid settings changes (such as add filter or reset report) are done in an Ajax request. Thus, the download data may not match the report data user is seeing. For this reason, Oracle recommends only using this procedure in a page submit process.Syntax
APEX_IG.CLEAR_REPORT (
p_page_id IN NUMBER,
p_region_id IN NUMBER,
p_report_id IN NUMBER DEFAULT NULL )
Parameters
Parameter | Description |
---|---|
p_page_id |
Page of the current Oracle APEX application that contains an interactive grid. |
p_region_id |
The interactive grid region ID. |
p_report_id |
The saved report ID within the current application page. If p_report_id is NULL, it clears the last viewed report settings.
|
Example
The following example shows how to use the CLEAR_REPORT
procedure signature 1 to reset interactive grid filter settings with report ID of
901029800374639010
in page 1, region
3335704029884222
of the current application.
BEGIN
APEX_IG.CLEAR_REPORT(
p_page_id => 1,
p_region_id => 3335704029884222,
p_report_id => 901029800374639010);
END;
Parent topic: APEX_IG