How to Make a Report from Database Records › Creating a report › Step 4— Enter additional selection criteria

Step 4— Enter additional selection criteria

In this step, you:

Specify Y to proceed to the Additional selection criteria screen.

      CA OLQ Release nn.n                          *** Column Select ***
  ->                                                       Page     1 of     2
 124000 Select columns, specify selection criteria and press the ENTER key

    Columns Currently Selected:    0     Selection Criteria     Distinct N Y/N
  _ EMPLOYEE
  x 02 EMP-ID-0415                   *
  _ 02 EMP-NAME-0415
  _ 03 EMP-FIRST-NAME-0415           *
  x 03 EMP-LAST-NAME-0415            *
  _ 02 EMP-ADDRESS-0415
  _ 03 EMP-STREET-0415
  x 03 EMP-CITY-0415                     eq boston
  _ 03 EMP-STATE-0415
  _ 03 EMP-ZIP-0415
  x 04 EMP-ZIP-FIRST-FIVE-0415
  _ 04 EMP-ZIP-LAST-FOUR-0415
  x 02 EMP-PHONE-0415
  _ 02 STATUS-0415
   Additional Selection Criteria:


                                   Proceed to Selection Criteria Screen? Y Y/N
 1=HELP       3=QUIT       4=MESSAGE       6=MENU       8=FWD       PA2=REFRESH

At the Selection criteria screen, specify additional retrieval selection criteria that restrict what data is retrieved from the database. In this sample, your additional selection criteria limit the employees whose:

• Area code (first 3 digits) is '508'
• City of residence is not one beginning with 'New'
• Zip code begins with a '01'

     CA OLQ Release nn.n                          ***Selection Criteria***
 ->                                                Line     1 Of     1
146000 Type in selection criteria, and press the ENTER key.
 Please Enter Additional Selection Criteria:
 (EMP-PHONE-0415 MATCHES '508#######') AND (EMP-CITY-0415 NOT LIKE 'NEW%'
OR EMP-CITY-0415 NOT LIKE 'BOSTON') AND (EMP-ZIP-FIRST-FIVE LIKE
'01###') 
















 1=HELP          3=QUIT          4=MESSAGE          6=MENU          PA2=REFRESH

More about additional selection criteria

The Additional selection criteria field works like the Selection criteria field, enabling you to enter simple and compound expressions. In addition, you can enter:

• Logical record keywords
• Criteria expressions for subscripted fields