Performing Query Functions › DB/CR Query Specifications Panel › DB/CR Query Specifications Entry Field Options › Example 1: Specifying Selection Criteria within the Charge element field

Example 1: Specifying Selection Criteria within the Charge element field

To generate a query with selection criteria and display results in a detail report:

• Set the Summarize and Break options to N (see A. below)
• Enter the selection criteria CPU-CHARGE in the area next to Charge Element (see B. below)

 +-- CBQCRDS ---DB/CR Query Specifications-----------------------------------+
 |      Panel   Exit   Help                                                  |
 | ------------------------------------------------------------------------- |
 | Type information for debit/credit query.  Then execute.                   |
 |                                                                           |
 | Summarize N  Break N      Version : PROD PROD                             |
 |             A.                         Brk                                |
 | ORD Type . . . . .                    N                                   |
 | Charge Element . . CPU-CHARGE   B.    N                                   |
 | Qualifier  . . . .                    N                                   |
 | Period Number  . .       thru         N                                   |
 | DIVISION . . . . .                    N                                   |
 | DEPARTMENT . . . .                    N                                   |
 + --------------------------------------------------------------------------+

The panel below shows the results of specifying selection criteria within the Charge Element field. Note the following:

• The number of records which meet the criteria is 5 (see A. below). This panel shows the first of the records selected from the DBCRTAB table.
• CA PMA Chargeback selects only those records with Charge Element = CPU-CHARGE (see B. below).

  USERID                      CA PMA Chargeback               MM/DD/YY HH:MM:SS
  __    Acctdefs   Cbdefs   Query   Data   Period   Options   Exit   Help
 
 +-- CBQCRDD -------------- Debit/Credit Query Results ------------------------+
 |       Panel   Exit   Help                                                   |
 | --------------------------------------------------------------------A.----- |
 |                                          More: + - 1     Row: 1    of 5     |
 |                                                                             |
 |  Version  . . . . : PROD PROD         Debit Amt  . :        250.00000       |
 |  ORD Type . . . . : MBJ               Credit Amt . :        150.00000       |
 |  Charge Element . : CPU-CHARGE  B.    Desc . . . . : DB/CR for Per1         |
 |  Qualifier  . . . : SHIFT1                                                  |
 |  Period Number  . : 1                                                       |
 |  DIVISION . . . . : RESTON                                                  |
 |  DEPARTMENT . . . : TECHWRIT                                                |
 |                                                                             |
 |                                                                             |
 |                                                                             |
 |                                                                             |
 |   F7=Bkwd   F8=Fwd                                                          |
 +-----------------------------------------------------------------------------+
 
  Command ===> ____________________________________________________________
  F1=Help  F3=Exit  F4=Prompt  F9=Command  F10=Action Bar  F12=Cancel  PA1=Susp