Performing Query Functions › Budget Query Specifications Panel › Budget Query Specifications Entry Field Options › Example 1: Specifying Selection Criteria within the ORD Type Field

Example 1: Specifying Selection Criteria within the ORD Type Field

The following panel shows how to generate a detail report of the records in the BUDTAB where ORD Type = MBJ.

• Set the Summarize and Break options to N.
• Enter MBJ in the area next to ORD Type (see A. below).

 +-- CBQBGTS -- Budget Query Specifications ---------------------------------+
 |      Panel   Exit   Help                                                  |
 | ------------------------------------------------------------------------- |
 | Type information for budget query. Then Execute.                          |
 |                                                                           |
   Summarize N  Break N      Version : PROD PROD                             |
  >
 |                           A.         Brk                                 |
 | ORD Type . . . . . MBJ                N                                   |
 | Charge Element . .                    N                                   |
 | Qualifier  . . . .                    N                                   |
 | Period Number  . .       thru         N                                   |
 | DIVISION . . . . .                    N                                   |
 | DEPARTMENT . . . .                    N                                   |
 +---------------------------------------------------------------------------+

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

• The number of records that meet the criteria ORD Type = MBJ is 11 (see A. on the next panel).
• This panel shows the first of the records selected from the BUDTAB table.
• The application displays all fields for each record.

  USERID                     CA PMA Chargeback                MM/DD/YY HH:MM:SS
  __    Acctdefs   Cbdefs   Query   Data   Period   Options   Exit   Help
 
 +-- CBQBGTD ----------------- Budget Query Results ---------------------------+
 |       Panel   Exit   Help                                                   |
 | ------------------------------------------------------------------A.------ |
 |                                          More: + - 0001  Row: 1    of 0011  |
 |                                                                             |
 |  Version  . . . . : PROD PROD         Budget Amt . :        600.00000       |
 |  ORD Type . . . . : MBJ               Description. : BUDFORPER1             |
 |  Charge Element . : CPU-CHARGE                                              |
 |  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