How to Make a Report from a Table › Creating Your Report From an SQL Table › Step 4— Specifying additional selection criteria

Step 4— Specifying additional selection criteria

Additional selection criteria

The Additional selection criteria field and the Selection Criteria screen, give you more room to add selection criteria for the rows of data you want in your report.

In this example, you want to report on those employees whose:

• Department ID is 4000 (already specified above)
• Phone exchange (first 3 digits) is '329'
• Last name begins with a 'C' or an 'S'
• State of residence is Massachusetts or New Hampshire
• Annual salary is greater than $40,000 and less than $100,000
• Start date with the company was after 1988
• Status is active (still an active employee)

Begin entering the additional selection criteria on this screen. Then specify Y to go to the Selection Criteria Screen for more room to enter selection criteria.

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

    Columns Currently Selected:    0     Selection Criteria     Distinct N Y/N
  _ EMPDEMO.EMPLOYEE
  _ 02 EMP_ID_0415
  s 02 EMP_LAST_NAME_0415
  _ 02 EMP_FIRST_NAME_0415
  _ 02 EMP_STREET_0415
  _ 02 EMP_CITY_0415
  s 02 EMP_STATE_0415
  _ 02 EMP_ZIP_FIRST_FIVE_0415
  _ 02 EMP_ZIP_LAST_FOUR_0415
  s 02 EMP_PHONE_0415
  s 02 EMP_SALARY_AMOUNT_0415
  s 02 EMP_START_YEAR_0415
  s 02 EMP_TERMAINATION_DATE_0415
  s 02 EMP_DEPT_ID                          eq 4000

 Additional Selection Criteria: EMP_PHONE_0415 = 329  


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

Finish entering the additional selection criteria.

     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 = 329 AND (EMP_LAST_NAME_0415 = 'C' OR EMP_LAST_NAME_0415
 = 'S') AND (EMP_STATE_0415 = 'MA' OR EMP_STATE_0415 = 'NH') AND (EMP_SALARY_
 AMOUNT_0415 > 40000 AND EMP_SALARY_AMOUNT_0415 < 100000) AND (EMP_START_YEAR_
 0415 > 88) AND (EMP_TERMINATION_DATE_0415 IS NOT NULL);  













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

With the Selection Criteria screen you can also enter:

• Exists predicates
• Quantified predicates (ANY, SOME, ALL)
• Nested select predicates
• Multiple criteria for the same command
• Group by, order by, and so on