Creating a temporary filter with CA View.

Document ID : KB000026510
Last Modified Date : 14/02/2018
Show Technical Document Details

Summary:

A temporary filter is created during the current session and remains in effect for the current session only. This type of filter can not be saved.

 

Instructions:

To create a temporary filter:

  1. Go into the report for which you want to create a filter.

  2. On the command line type one of the following commands:

    1. FIL CREATE

    2. FILTER C

    3. FILTER CREATE

  3. Hit enter and the Filter Definition Specifications panel is displayed. You define the filter on this panel. You can specify three basic
    components for the filter:

    1. The area of the report page and line to search using the BEG(inning) and END record or line and BEG(inning) or END column.

    2. A rule containing the text strings to be found using the OP(erator) and Text fields

    3. The action to take when the rule is true (color, underscore, do not display, and so on)


    Figure 1

    Note the comment in the upper right hand corner:
    It tells you this type of filter can not be saved beyond the current session'

  4. Fill in the number of the first record or line and the last record or line from the unfiltered report to be
    searched for the Text criteria.

    1. If neither Beg nor End is specified, the entire page is searched.

    2. If only Beg is specified, only that one line is searched.

    3. If both Beg and End are specified, only those lines (including all lines in between) are searched.

  5. Next fill in the column number from the unfiltered report to begin searching for the data specified in the Text
    field and the column to stop searching.

    1. If neither Beg nor End is specified, the entire line is searched.

    2. If only Beg is specified, only that one column is searched.

    3. If both Beg and End are specified, only those columns (including al columns in between) are searched.

  6. Fill in the OP(erator) and Text string

    1. Operators can be EQ (equal)
      NE (not equal)
      LT (less than)
      GT (greater than)
      LE (less than or equal)
      GE (greater than or equal

    2. When an operator other then EQ is used, column numbers should always be specified in order to get the
      desired results. In the following example, if no column numbers were specified for the NE line, the search
      rule would be "find any string on the line that is not equal to 216." Since every line of the report except
      one has a text string that is not equal to 216, you get all the lines instead of the one that you wanted
         Example: CA-View ALL ---------- Filter Definition Specifications ----- Row 00001 of 00002 Command ===> Scroll ===> PAGE  Filter ID ---> ZERICG4 Description ===> EXAMPLE 4  Filter  Specifications: Lines     Columns -Emphasis-- Sel Beg End Beg End Op Text                                                       Type Show Clr Hlt Loc 19         EQ 'HUMAN RESOURCES'                                                   AND   Y  3          NE '216' ******************************** BOTTOM OF DATA ********************************   The following is the report browsed with the filter selected and activated:   CA-View Browse - PROVRPT -------- Rec 0000000 Pg 0000001.067 Lock 00 Col 001 080 Command ===> Scroll ===> PAGE ******************************** TOP OF DATA *********************************** . 312 555 201 HUMAN RESOURCES 15 2465 WORTH KENNE ******************************** BOTTOM OF DATA ********************************      
  7. The Text field is case-sensitive and can contain blanks if enclosed in quotes.

  8. The Type field specifies the Boolean connectors: AND, OR, NOT that are used to specify how multiple search texts
    are to be used.

    1. The NOT connector must appear on its own line, and it refers to the line that follows it.

    2. When using AND, all comparisons must have the same line numbers.

  9. The Show field specifies whether lines that match the search criteria should be displayed (Y or N)

  10. The Clr field is used to specifies the color that should be used to display the line

    1. Available colors are white, red, blue, green, pink, yellow, or turquoise.

    2. Only the first letter of the color needs to be filled in.
  11. The Hlt field specifies the type of highlighting that should be used when displaying the line.

    1. Available highlights are underscore, blink, or reverse video.

    2. Only the first letter of the highlight needs to be filled in.

  12. The Loc field specifies how to apply the color and highlighting to the occurrences of the specified Text string that
    were found.

    1. Fill in A, if you want the coloring and highlighting to be applied to ALL occurrences of the specified Text string
      on the report line

    2. Fill in F, if you want the coloring and highlighting to be applied to the first occurrence of the specified Text
      string on the report line

    3. Fill in L If you want the coloring and highlighting to be applied to the entire report line

Now that the filter is created, what commands can be used to turn the filter on and off?

  1. On the command line type one of the following commands to turn the filter on:

    1. FIL N

    2. FILTER N

    3. FIL ON

  2. On the command line type one of the following commands to turn the filter off:

    1. FIL F

    2. FILTER F

    3. FIL OFF and hit PF7 because you are at the bottom of the report.