IR_FILTER Procedure

This procedure creates a filter on an interactive report.

Syntax

APEX_UTIL.IR_FILTER(
    p_page_id       IN NUMBER,
    p_report_column IN VARCHAR2,
    p_operator_abbr IN VARCHAR2 DEFAULT NULL,
    p_filter_value  IN VARCHAR2,
    p_report_alias  IN VARCHAR2 DEFAULT NULL);

Parameters

Table: IR_FILTER Parameters describes the parameters available in IR_FILTER procedure.

IR_FILTER Parameters

Parameter	Description
`p_page_id`	Page of the current APEX application that contains an interactive report.
`p_report_column`	Name of the report SQL column, or column alias, to be filtered.
`p_operator_abbr`	Filter type. Valid values are as follows: EQ = Equals NEQ = Not Equals LT = Less than LTE = Less then or equal to GT = Greater Than GTE = Greater than or equal to LIKE = SQL Like operator N = Null NN = Not Null C = Contains NC = Not Contains IN = SQL In Operator NIN = SQL Not In Operator
`p_filter_value`	Filter value. This value is not used for 'N' and 'NN'.
`p_report_alias`	Identifies the saved report alias within the current application page. To create a filter on a Primary report, `p_report_alias` must be 'PRIMARY' or leave as NULL. To create a filter on a saved report, `p_report_alias` must be the name of the saved report. For example, to create a filter on report '1234', `p_report_alias` must be '1234'.

Example

The following example shows how to use the IR_FILTER procedure to filter Interactive report with alias of '8101021' in page 1 of the current application with DEPTNO equals 30.

BEGIN
    APEX_UTIL.IR_FILTER (   
        p_page_id        => 1,
        p_report_column  => 'DEPTNO',
        p_operator_abbr  => 'EQ',
        p_filter_value   => '30'
        p_report_alias   => '8101021'
        );
END;