42/78
3.7.3 Adding a Filter
Create row and column filters on an interactive report.
3.7.3.1 About Creating Filters
You can create a filter on an interactive report by adding or modifying the WHERE
clause on the query.
You can create two types of filters:
-
Column - Creates a custom column filter. Select a column, select a standard Oracle operator (=
, !=
, not in
, between
), and enter an expression to compare against. Expressions are case sensitive. Use the percent sign (%)
as a wildcard. Note that the selected column does not need to be one that currently displays. For example:
STATE_NAME like A%
-
Row - Creates a custom row filter. This filter creates a complex WHERE
clauses using column aliases and any Oracle functions or operators. For example:
G = 'VA' or G = 'CT'
Where G
is the alias for CUSTOMER_STATE
.
3.7.3.2 Adding, Editing, and Removing a Column Filter
Use the Actions menu to add, edit, or remove a column filter in an interactive report.
To add a column filter:
- Click the Actions menu and select Filter.
The Filter dialog appears.
- For Filter Type, select Column.
- In the Filter region, specify a column, an operator, and an expression and click Apply.
Notice the filter that displays in the Report Settings area above the report. You can show or hide the filter details by clicking the arrow to the left of the filter name.
To revise the filter:
- Click the filter name (in this example,
Project = 'Discussion Forum'
).
- Edit your selections and click Apply.
- To disable the filter, select the Enable/Disable Filter check box.
- To delete the filter, click Remove Filter.
3.7.3.3 Adding, Editing, and Removing a Row Filter
Use the Actions menu to add, edit, or remove a row filter in an interactive report.
To add a row filter:
- Click the Actions menu and select Filter.
The Filter dialog appears.
- For Filter Type, select Row.
- In the Filter dialog:
- Name - Enter a name that describes this filter.
- Filter Expression - Enter an expression. Select a column and function or operator at the bottom of the region. For example,
I >=2500
displays projects costing more than $5000.
- Click Apply.
Notice the filter that displays in the Report Settings area above the report. You can show or hide the filter details by clicking the arrow to the left of the filter name.
- To revise the filter:
- Click the filter name.
- Edit your selections and click Apply.
- To disable the filter, select the Enable/Disable Filter check box.
- To delete the filter, click Remove Filter.