Use the Edit Filter window to apply conditions to the columns within a report to further select or restrict objects on which you want to report. Filters enable you to apply general rules to the report. For example, you can show only the tablespaces that contain over 80% used space, or select all tablespaces with percent used space >= to a specific value.
The following table describes the fields that appears on the Edit Filter window:
Field Name |
Description |
Add |
Press this button to specify multiple conditions for the filter. When you click Add, report columns will be displayed enabling you to define conditions for those columns. |
Delete All |
Press this button to delete all the conditions displayed on the table. |
Case-sensitive string comparisons |
Check this box to ensure that values appearing in the generated report match the case of the values entered in the Value 1 and Value 2 fields. |
Records must meet
|
Use this field to specify how the conditions in the filter are grouped together.
|
Column |
Use this field to select specific columns on which you want to define conditions. The drop-down lists the columns available for the report. As you select the column from the drop-down list, it is displayed on the table, and the column name is removed from all other drop-down lists.
Click |
Operator |
Select the condition's operator. Not all operators apply to all column data-types. |
Value 1/
|
Specify fixed value(s) to be compared against the record's column value.
Depending on the operator and data-type, this field may be absent or display-only. If the field is display-only, an Edit button will be enabled. If both this field and the Edit button are enabled, this field allows shorthand value entry. If you click the Edit button, a dialog box is displayed to provide more assistance in editing the value.
A Value 2 field will be present only for (NOT) BETWEEN. |
Edit |
Click this button to edit values pertaining to size, date, and for specific values used for IN, LIKE, etc. operators. Depending on the condition you are creating, a dialog box displays to help you to enter values that correspond to the condition. |
OK |
Click this button to save the filter. You are returned to the Selection tab. The Filter button will display a red triangle to indicate that a filter has been defined for the report. |
Cancel
|
Click this button to return to the Selection tab without saving the filter. |
Related Topics
Working with Reports
Selecting Resources Upon Which to Report
Filtering the Resources that Appear in a Report
Trending with Historical Data