Creating a defined filter

Follow these steps to create a defined filter.

Procedure

Access the Filter Maintenance panel.

Type CREATE in the Option line and press Enter.

The Create Filter panel is displayed:

Figure 1. Create Filter panel

CQM$FNA8 ----------------- Create Filter ------------------------- 
Option  ===> _________________________________________________     
                                                                   
  Filter Name ............ ________                                
  Description ............ ________________________________        
                                                                   
  Press Enter to create filter or PF3/CANCEL to exit

These display and input fields are shown on the Create Filter panel:

Filter Name: The name of the filter being created.
Description: The description of the filter being created.

Specify a filter name and description and press Enter. The Create Filter panel displays:
Figure 2. Create Filter panel
```
CQM$FLTC 2 17:14:51  ----------- Create Filter ----------  No rows to display  
Option  ===>                                                  Scroll ===> PAGE 
                                                                               
  Type "CREATE" on command line to create filter line                          
                                                                               
  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                                                         
 -   -------- -- --------------------------------------------------------------
```
The input fields that display on the Create Filter panel include:
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, thus CQM data must meet the criteria of all defined filter lines for it to be displayed) and OR (joins line items by the OR operator, thus CQM data must meet the criteria of at least one defined filter line for it to be displayed). This 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 CQM 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 CQM 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 CQM 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 CQM data with Programs that start with 'CQM@S' or end with '7' will display.
The line commands available on the Create Filters panel include:

Create (Primary command CREATE)

Create a new filter line.

I - Insert

Inserts a new filter line below the selected line.

U - Update

Update a filter line.

V - View

View a filter line.

R - Repeat

Repeat a filter line.

D - Delete

Delete a filter line.