Working with active filters

Enable and tailor your active filters as needed to show the data most important to you.

Procedure

Type FILTER in the Option field of a panel that allows filtering and press Enter.
The Active Filters panel is displayed:
Figure 1. Active Filters panel
```
--------------------- Active Filters --------------------  ROW 1 OF 1          
Option  ===> _________________________________________________________________ 
                                                                               
  Type "CREATE" on command line to create filter line                          
                                                                               
  Enable Filtering......... N  (Y/N)   Mixed Case … Y (Y/N)                                                
  Exclude Filtered Data.... N  (Y/N)  Match Case … N (Y/N)                             
  Display Defined Filters.. N  (Y/N)                                           
  Filter Dataset Name...... ____________________________________________       
                                                                               
  AND/OR between columns... AND  (AND/OR)                                      
  AND/OR within a column... OR_  (AND/OR)                                      
                                                                               
C:I-Insert,U-Update,V-View,R-Repeat,D-Delete                                   
------------------------------------------------------------------------     > 
CMD  Column   OP Value                                                         
 -   -------- -- -------------------------------------------------------------
 _   PLAN     EQ PLANA                                                         
************************** Bottom of Data *******************************                                                                              
  Press Enter/PF3 to update filter variables or CANCEL to exit                 
```
The following fields are available:
Enable Filtering

Enable or disable filters for the current display. Valid values are Y (filters are active for the current display) and N (filters are not active for the current display).

Exclude Filtered Data

Indicates whether the data you define in the filter is to be excluded from your view. Valid values are Y (excludes data matching your filter criteria from display) and N (does not exclude data matching your filter criteria from display; matching data is displayed).

Mixed case

Indicates whether the data you define in the filter contains mixed case characters. Valid values are Y (data contains mixed case) and N (data does not contain mixed case). Mixed case set to N does not alter the value you enter, it simply controls whether or not data is translated to upper case prior to display. However, if you set Mixed Case to N and you modify a value, it will be stored in upper case.

Match case
Indicates whether the filter applies as entered or whether all values are treated as if they were entirely upper case. Valid values are Y (match values as entered) and N (treat all values as upper case). Match Case set to N does not alter the value you enter, it simply controls whether or not a copy of the data values to be compared are translated to upper case prior to comparison. The combination of Mixed Case and Match Case settings operate according to the following:
- (Default) Mixed case=Y and match case=N. Filter values are stored as entered but filter values and field values are treated as upper case for comparison.
- Mixed case=Y and match case=Y. Filter value are stored as entered but filter values and filed values are compared as is.
- Mixed case=N and match case=N. Filter values are upper cased when stored and field values are treated as upper case for comparison.
- Mixed case=N and match case=Y. Filter values are upper cased when stored and comparison are made to field values, as is.
Display Defined Filters

Indicates whether or not to display existing filters. Valid values are Y (displays existing filters) and N (does not display existing filters). If you specify Y in the Display Defined Filters field, you must also specify the name of the data set that contains defined filters in the Filter Dataset Name field.

Filter Dataset Name
The name of the data set you created to hold Db2® Query Monitor filters. If you specify a fully-qualified data set name, the name must be enclosed in single-quotes, for example:
```
'TWUSER.CQM.FILTERS'
```
AND/OR between columns
Indicates whether line items for a filter are joined by the AND or the OR operator. Valid values are

AND

Joins line items by the AND operator. Db2 Query Monitor data must meet the criteria of all defined filter lines for it to be displayed.

OR

Joins line items by the OR operator. Db2 Query Monitor data must meet the criteria of at least one defined filter line for it to be displayed.

The AND/OR between columns field defines the behavior of filter lines for different columns. For example, there might be two filter lines, one for Plan and another for Program, such as:
```
PROGRAM EQ CQM@S*
```
```
PLAN EQ DIST*
```
In such a case, if the AND/OR between columns field is set to AND for an active filter, then only Db2 Query Monitor data with Programs that starts with 'CQM@S' and Plans that start with 'DIST' will display. If the AND/OR between columns field is set to OR for an active filter, then Db2 Query Monitor data with Programs that start with 'CQM@S' or Plans that start with 'DIST' will display.
AND/OR within a column
Indicates whether columns within a filter are joined by the AND or the OR operator. Valid values are AND (joins columns within a filter by the AND operator) and OR (joins columns within a filter by the OR operator). This field defines the behavior of filter lines that are defined for the same column. For example, there might be two filter lines for the Program column, such as:
```
PROGRAM EQ CQM@S*
```
```
PROGRAM EQ *7
```
In such a case, if the AND/OR within a column field is set to AND for an active filter, then only Db2 Query Monitor data with Programs that starts with 'CQM@S' and end with '7' will display. If the AND/OR within a column field is set to OR for an active filter, then Db2 Query Monitor data with Programs that start with 'CQM@S' or end with '7' will display.
The following commands are available:

Create (Primary command CREATE)

When you type CREATE in the option line and press Enter, the Create Filter Line panel displays where you can define the column name, operator, and column value for the filter line.

I - Insert

Insert a new filter line below the selected line. The Create Filter Line panel is displayed, where you can define the column name, operator, and column value for the filter line.

U - Update

Update the column name, operator, and column value for a filter line.

V - View

View the column name, operator, and column value for the selected filter line.

R - Repeat

Repeat the selected line, placing a copy directly below the line on which you specified the R line command.

D - Delete

Delete the filter line.
Create or modify active filters as needed and press Enter to save.