48.83 IR_FILTER Procedure [DEPRECATED]

Note:

This procedure is not recommended. This procedure has been replaced by the procedure in APEX_IR.

This procedure creates a filter on an interactive report. Only use this procedure in a page submit process.

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 48-71 IR_FILTER Parameters

Parameter	Description
p_page_id	Page of the current Oracle 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;