Entry Field Options: WHERE (condition)

Performing Query Functions › Charge Query Panels › Charge Query Specifications Entry Field Options › Entry Field Options: WHERE (condition)

Entry Field Options: WHERE (condition)

If you wish to select only those records that meet a specific criteria, you can add a conditional test next to any of the panel fields. This test can be a predefined user name, a number, or a number to be used with a comparison operator (<, >, =) specified in the Op column. The following table shows valid criteria for each of the entry fields:

Entry Field	Type of Criteria
ORD Type	Predefined user name
Charge Element	Predefined user name
Qualifier	Predefined user name
Period Number	Number (up to 3 digits)
Accounting Structure (1 - 5)	Predefined accounting level
Rec Count	Number and comparison operator in Op column
Units	Number and comparison operator in Op column
Rate	Number and comparison operator in Op column
Charge	Number and comparison operator in Op column

Note: If you request a summary or a summary-with-breaks report, specifying selection criteria within the Rec Count, Units, Rate, and Charge fields causes the generation of a SQL HAVING clause instead of a WHERE clause. The SQL HAVING clause is similar to SQL WHERE clause, but qualifies groups rather than individual fields.

CA PMA Chargeback can display results in any format, regardless of the criteria you specify. The examples that follow show summary and summary-with-breaks reports.