Setting a complex filter (using the View Customization dialog)

Use the following procedure to limit the data shown in a view by setting complex filter conditions.

To set a complex filter

1. Specify an element that you want to filter:

   1. On the COMMAND line of the view that you want to filter, type WHATis.

   2. Place your cursor on the field for the element to be filtered and press Enter.The Field Information window displays the internal name of the element that is associated with this field.

      Example

      Assume that you entered WHATis from the Plex Manager TGTDEF view and selected the Product field with your cursor. The Field Information window displays the element name as TGTDPROD.

   3. Note the name of the element as shown in the Field Information window, then press PF3 to exit.
      
      

   Note

   For the remainder of this procedure, examples assume that you are using the TGTDEF view to filter data to only products with names that start with MVI or MVV.

2. On the view's COMMAND line, type CUST and press Enter.
   
   

3. In the OPTION field, type P and press Enter.The customization dialog is displayed:

   
   

   ------------------------ VIEW CUSTOMIZATION - TGTDEF --------------------------
   OPTION  ===> p                                                SCROLL ===> HALF
   Options: (that require column selection)       Other options:
   F - Format    M - Move       I - Include       G - Graph      S - Save view
   O - Order     R - Repeat     X - Exclude       P - Parameters E - Show excluded
   L - Filter    T - Threshold  H - Hyperlink     Z - Summarize  K - Show template
   --------------------< Positional Parameters for TGTDEF   >---------------------
   # Col Element      Filter               # Col Element      Filter
   1                                       5
   2                                       6
   3                                       7
   4                                       8
   -------------------------------------------------------------------------------
   This data displays filters, when QWHERE and/or WHERE commands were issued.
   QWHERE
   
   
   WHERE
   
   
   -------------------------------------------------------------------------------
       A        B        C        D                                E
   CMD CAS      Target   Product  Description                      Install
   --- Name---- Name---- -------- ------------                     Status--

4. After QWHERE or WHERE, enter a filter condition.

   Example

   After WHERE, enter the following string to show only products with names that start with MVI or MVV:

   (TGTDPROD = MVI*) OR (TGTDPROD = MVV*)

   Conditional expressions must be enclosed in parentheses. For additional information about using QWHERE and WHERE with the P option, see the filtering information in the online Help.
   
   

5. Scroll down and press Enter to see the filtering results.The WHERE command has applied the filter conditions against the data, and the view is updated as follows:

   
   

   ddmmmyyyy hh:mm:ss -------- MAINVIEW WINDOW INTERFACE (Vv.r.mm) --------------
   COMMAND  ===>                                                 SCROLL ===> HALF
   CURR WIN ===> 1        ALT WIN ===>
   >W1 =TGTDEF============SYSB=====*========(99 BROWSE        )====PLEXMGR==U===22
   CMD CAS      Target   Product  Description                      Install
   --- Name---- Name---- -------- ------------                     Status--
       SYSA     IMSM     MVIMS    IMS                              Installed
       SYSA     DB2P     MVVP     BBCS TEST DB2 V3                 Installed
       SYSA     DB2X     MVVP     BBCS PROD DB2 V3                 Installed
       SYSA     IMSM     MVVP     IMS                              Installed
       SYSA     ETCCIC4  MVVP     EMPRISE TECH CICS V4.1           Not Installed
6. (Optional) Enter additional filtering conditions for additional elements, if needed.
7. When finished, press the END (PF3) key.
8. In the Save changes field, type YES.

9. When prompted for the following information about the new view, complete each field and press Enter:

   • View name
   • Replace
   • Description
   • Dynamic fields
   • Summary view
   • Threshold Location

   For descriptions of these fields, see the online Help.