Setting a complex filter (using the COMMAND line)

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

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.

   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. Place your cursor on the field for the element to be filtered and press Enter.

   Tip

   Make note of the name of the element so you do not have to repeat this step.

   The remainder of this example uses the TGTDEF view to filter data to only those products with names that start with MVI or MVV.

   Example

   By entering WHATis from the Plex Manager TGTDEF view and selecting the Product field with your cursor, a Field Information window displays with an Element Name of TGTDPROD for Product data elements.

3. On the COMMAND line of the view you want to filter, type QWHERE or WHERE and press Enter.The dialog is displayed for the WHERE command and a similar one is displayed for the QWHERE command:

   
   

      ------------------------------- SET WHERE FILTER --------------------------
      COMMAND  ===>
   
      Where Condition:
   
   
   
   
       Type END to update the form filter
            CANcel to quit without updating

4. Enter your filter conditions as shown below:

   
   

     ------------------------------- SET WHERE FILTER --------------------------
     COMMAND  ===>
   
     Where Condition:
     (TGTDPROD = MVI*) OR (TGTDPROD = MVV*)
   
   
   
      Type END to update the form filter
           CANcel to quit without updating

   For this example, under Where Condition, enter the string to construct a WHERE command:

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

   TGTDPROD is the element name for the Product data field. The condition is to show only those products with names that start with MVI or MVV. Conditional expressions must be enclosed in parentheses.
   
   

5. On the COMMAND line, type END and press Enter to see the results of the complex filter that you set:The WHERE command has applied the filter conditions against the data and the view is updated with data that meets the filter conditions as shown in the following dialog:

   
   

   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

   Note

   Any previously specified filter is replaced with the new filter.

6. If you want to save the view with the new filters, enter view customization with the CUSTom command and use the S option to save the view.