53.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
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:
|
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;
Parent topic: APEX_UTIL