This procedure creates a filter on an interactive report using a report ID.
Syntax
APEX_IR.ADD_FILTER( p_page_id IN NUMBER, p_region_id IN NUMBER, p_report_column IN VARCHAR2, p_filter_value IN VARCHAR2, p_operator_abbr IN VARCHAR2 DEFAULT NULL, p_report_id IN NUMBER DEFAULT NULL);
Parameters
Table 11-1 describes the available parameters for the ADD_FILTER procedure signature 1.
Table 11-1 ADD_FILTER Procedure Signature 1 Parameters
Parameter | Description |
---|---|
|
Page of the current Application Express application that contains an interactive report. |
|
The interactive report region (ID). |
|
Name of the report SQL column, or column alias, to be filtered. |
|
The filter value. This value is not used for N and NN. |
|
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 NLIKE = Not Like N = Null NN = Not Null C = Contains NC = Not Contains IN = SQL In Operator NIN = SQL Not In Operator |
|
The saved report ID within the current application page. If |
Example
The following example shows how to use the ADD_FILTER
procedure to filter the interactive report with report ID of 880629800374638220 in page 1, region 2505704029884282 of the current application with DEPTNO
equals 30.
BEGIN APEX_IR.ADD_FILTER( p_page_id => 1, p_region_id => 2505704029884282, p_report_column => 'DEPTNO', p_filter_value => '30', p_operator_abbr => 'EQ', p_report_id => 880629800374638220); END;