23.5 CLEAR_REPORT Procedure Signature 2

This procedure clears filter report settings to the developer defined default settings using the report name.

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_name IN VARCHAR2 DEFAULT NULL); 

Parameters

Table 23-5 CLEAR_REPORT Procedure Signature 2 Parameters

Parameter	Description
p_page_id	Page of the current Application Express application that contains an interactive grid.
p_region_id	The interactive grid region (ID).
p_report_name	The saved report name within the current application page. If p_report_name is NULL, it resets the last viewed report settings.

Example

The following example shows how to use the CLEAR_REPORT procedure signature 2 to reset interactive grid filter settings with report name of 'Statistics' in page 1, region 3335704029884222 of the current application.

BEGIN     
    APEX_IG.CLEAR_REPORT(
        p_page_id      => 1,
        p_region_id    => 3335704029884222,
        p_report_name  => 'Statistics');
END;