This section presents four examples using filters.
Example 1
This report lists all accounts, including phone numbers and cost centers:
CA View Browse ---- PROVRPT ---- Rec 0000000 Pg 0000000.000 Lock 00 Col 001 080 Command ===> Scroll ===> PAGE ********************************* TOP OF DATA ********************************** .SARPAGE 1 . . TBEXPFCN TELECOMMUNICATIONS BILLIN . FREQUENTLY CALLED NUMBERS . FOR PERIOD 05/25/2013 THRU 06/01/ ........................................................---------NAME---------- ..DIALED NUMBER........COSTCENTER ....STAT/AUTH CD.....LAST...............FIRS . 216 222 3333 ACCOUNTING SERVICES 15 2230 ACCOUNTING SERVICES . 216 222 3344 PRINT 15 2635 PRINT . 216 222 3355 SPECIALTY AUTO APM 15 2657 COLLIN DARRY . 216 222 3366 OUTSIDE PROD MGR 15 2411 LAMBERS DAVID . 216 222 3534 HUMAN RESOURCES 15 2463 HUMAN RESOURCES . 216 222 3360 HUMAN RESOURCES 15 2465 RUSSEL RACHA . 216 222 3560 HUMAN RESOURCES 15 2647 HENRY WILLI . 216 222 3360 HUMAN RESOURCES 15 2465 RUSSEL RACHA . 216 222 3530 TRAINING 15 2647 HENRY SHARI . 216 222 4233 TRAINING 15 2646 SOFTWARE TRAINING . 216 222 4234 TRAINING 15 2647 QUAN SUSIE
In this example:
CA View ALL ---------- Filter Definition Specifications ---- Row 00001 OF 00001 Command ===> Scroll ===> PAGE
Filter ID ---> ZERICG -Emphasis-- Description ===> THIS IS ERIC'S FILTER Filter Specifications: C H L Lines Columns l l 0 Sel Beg End Beg End Op Text Type Show r t c 19 EQ 'HUMAN RESOURCES' Y
******************************* BOTTOM OF DATA ********************************
Note: Use the SAVE command to save the definition—if you press PF3/END the definition is not saved.
The filter in the previous example specifies that CA View must display each line containing the text HUMAN RESOURCES starting in column 19. (By leaving the Col End field, blank, you specify that CA View is to start in column 19 and check for the length of the specified text string.)
This is the report that is browsed with the filter selected and activated:
CA View Browse ---- PROVRPT ---- Rec 0000000 Pg 0000001.013 Lock 00 Col 001 080 Command ===> Scroll ===> PAGE ********************************* TOP OF DATA ********************************** . 216 222 3534 HUMAN RESOURCES 15 2463 HUMAN RESOURCES . 216 222 3360 HUMAN RESOURCES 15 2465 RUSSEL RACHA . 216 222 3560 HUMAN RESOURCES 15 2647 HENRY WILLI . 216 222 3360 HUMAN RESOURCES 15 2465 RUSSEL RACHA . 216 222 2011 HUMAN RESOURCES 15 2462 WORTH KENNE . 312 555 2012 HUMAN RESOURCES 15 2462 WORTH KENNE ******************************** BOTTOM OF DATA ********************************
Example 2
This report lists all accounts, including phone numbers and cost centers:
CA View Browse - PROVRPT ------- Rec 0000000 Pg 0000000.000 Lock 00 Col 001 080 Command ===> Scroll ===> PAGE ********************************* TOP OF DATA ********************************** .SARPAGE 1 . . TBEXPFCN TELECOMMUNICATIONS BILLING . FREQUENTLY CALLED NUMBERS . FOR PERIOD 05/25/2013 THRU 06/01/ ........................................................---------NAME---------- ..DIALED NUMBER........COSTCENTER ....STAT/AUTH CD.....LAST...............FIRS . 216 222 3333 ACCOUNTING SERVICES 15 2230 ACCOUNTING SERVICES . 216 222 3344 PRINT 15 2635 PRINT . 216 222 3355 SPECIALTY AUTO APM 15 2657 COLLIN DARRY . 216 222 3366 OUTSIDE PROD MGR 15 2411 LAMBERS DAVID . 216 222 3534 HUMAN RESOURCES 15 2463 HUMAN RESOURCES . 216 222 3360 HUMAN RESOURCES 15 2465 RUSSEL RACHA . 216 222 3560 HUMAN RESOURCES 15 2647 HENRY WILLI . 216 222 3360 HUMAN RESOURCES 15 2465 RUSSEL RACHA . 216 222 3530 TRAINING 15 2647 HENRY SHARI . 216 222 4233 TRAINING 15 2646 SOFTWARE TRAINING . 216 222 4234 TRAINING 15 2647 QUAN SUSIE
In this example, you create a filter that does not display lines that have their cost center as HUMAN RESOURCES.
To create this filter, use this filter specification:
CA View ALL ------------- Filter Definition Specifications -- Row 00001 of 00001 Command ===> Scroll ===> PAGE Filter ID ---> ZERICG2 -Emphasis-- Description ===> EXAMPLE 2 Filter Specifications: C H L Lines Columns l l 0 Sel Beg End Beg End Op Text Type Show r t c 19 EQ 'HUMAN RESOURCES' N ******************************* BOTTOM OF DATA ********************************
This example shows the report browsed with the filter selected and activated:
CA View Browse - PROVRPT ------- Rec 0000001 Pg 0000001.001 Lock 00 Col 001 080 Command ===> Scroll ===> PAGE .SARPAGE 1 . . TBEXPFCN TELECOMMUNICATIONS BILLING . FREQUENTLY CALLED NUMBERS . FOR PERIOD 05/25/2013 THRU 06/01/ ........................................................---------NAME---------- ..DIALED NUMBER........COSTCENTER ....STAT/AUTH CD.....LAST...............FIRS . 216 222 3333 ACCOUNTING SERVICES 15 2230 ACCOUNTING SERVICES . 216 222 3344 PRINT 15 2635 PRINT . 216 222 3355 SPECIALTY AUTO APM 15 2657 COLLIN DARRY . 216 222 3366 OUTSIDE PROD MGR 15 2411 LAMBERS DAVID . 216 222 3530 TRAINING 15 2647 HENRY SHARI . 216 222 4233 TRAINING 15 2646 SOFTWARE TRAINING . 216 222 4234 TRAINING 15 2647 QUAN SUSIE . 216 222 6111 SPECIAL EVENTS 07 3879 SPECIAL EVENTS . 216 222 4405 SPECIAL EVENTS 07 3889 SPECIAL EVENTS AB . 216 222 5132 FINANCE AND ACCT 04 7245 SMITH JOHN . 216 222 3530 BANK OF AMERICA OPER 16 2013 WEBER PETER . 216 222 423 NC CAS CUST SER 12 2013 ENTRAL JILL
Example 3
This report lists all accounts, including phone numbers and cost centers:
CA View Browse ---- PROVRPT ---- Rec 0000000 Pg 0000000.000 Lock 00 Col 001 080 Command ===> Scroll ===> PAGE ********************************* TOP OF DATA ********************************** .SARPAGE 1 . . TBEXPFCN TELECOMMUNICATIONS BILLIN . FREQUENTLY CALLED NUMBERS . FOR PERIOD 05/25/2013 THRU 06/01/ ........................................................---------NAME---------- ..DIALED NUMBER........COSTCENTER ....STAT/AUTH CD.....LAST...............FIRS . 216 222 3333 ACCOUNTING SERVICES 15 2230 ACCOUNTING SERVICES . 216 222 3344 PRINT 15 2635 PRINT . 216 222 3355 SPECIALTY AUTO APM 15 2657 COLLIN DARRY . 216 222 3366 OUTSIDE PROD MGR 15 2411 LAMBERS DAVID . 216 222 3534 HUMAN RESOURCES 15 2463 HUMAN RESOURCES . 216 222 3360 HUMAN RESOURCES 15 2465 RUSSEL RACHA . 216 222 3560 HUMAN RESOURCES 15 2647 HENRY WILLI . 216 222 3360 HUMAN RESOURCES 15 2465 RUSSEL RACHA . 216 222 3530 TRAINING 15 2647 HENRY SHARI . 216 222 4233 TRAINING 15 2646 SOFTWARE TRAINING . 216 222 4234 TRAINING 15 2647 QUAN SUSIE
In this example, you create a filter that displays only those lines that contain the cost center HUMAN RESOURCES and does not display the lines with the 216 area code.
To create this filter, use this filter specification:
CA View ALL ---------- Filter Definition Specifications ----- Row 00001 of 00002 Command ===> Scroll ===> PAGE Filter ID ---> ZERICG3 -Emphasis-- Description ===> EXAMPLE 3 Filter Specifications: C H L Lines Columns l l o Sel Beg End Beg End Op Text Type Show r t c 19 EQ 'HUMAN RESOURCES' Y 3 EQ '216' N ******************************* BOTTOM OF DATA ********************************
The following shows 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 ********************************
Example 4
This example modifies the data in Example 3 to display each line that contains HUMAN RESOURCES in line 19 and does not contain area code 216 in column 3.
For each line, if column 19 has the text HUMAN RESOURCES, and if column 3 is not equal to 216, the line is displayed.
CA View ALL ---------- Filter Definition Specifications ----- Row 00001 of 00002 Command ===> Scroll ===> PAGE Filter ID ---> ZERICG4 -Emphasis-- Description ===> EXAMPLE 4 Filter Specifications: C H L Lines Columns l l o Sel Beg End Beg End Op Text Type Show r t c 19 EQ 'HUMAN RESOURCES' AND Y 3 NE '216' ******************************** BOTTOM OF DATA ********************************
This 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 ********************************
Important! Always do the following:
Specify the column to be searched when using the inequality operators—NE (not equal), LT (less than), GT (greater than), LE (less than or equal), and GE (greater than or equal).
When a comparison operator other than EQ is used, it is important to specify column numbers.
If no column numbers are specified in this example, the condition would have been "find any string on the line that is not equal to 216." Since every line of the report has a text string that is not equal to 216, you would not get the desired results.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|