Performing Query Functions › DB/CR Query Specifications Panel › DB/CR Query Specifications Entry Field Options

DB/CR Query Specifications Entry Field Options

CA PMA Chargeback supports standard SQL queries. The format of the SQL query is:

SELECT fieldname FROM tablename WHERE (condition) [ORDER BY fields]

The following sections discuss how to use the various entry fields with the processing options to generate SQL queries.

SELECT (fieldname).....

You can select fields from the DBCRTAB table for viewing in one of two ways:

• Detail report
• Summary-with-breaks report

If you select a detail report, the Summarize and Break options are both set to N. CA PMA Chargeback displays all fields of the DBCRTAB table for those records which meet any selection criteria specified.

If you select a summary-with-breaks report, the Summarize and Break options are both set to Y. CA PMA Chargeback groups results based on the fields you select in the Brk column. To select the fields you want results grouped by, enter Y in the appropriate space in the Brk column. The default value is N.

Note: Make sure the Break field is set to Y, otherwise CA PMA Chargeback ignores the values entered in the Brk column.

The Break option cannot be selected without also selecting the Summarize option.

from (tablename).....

The DB/CR Query Specifications panel allows access to information contained in the DBCRTAB. This is the default value and cannot be changed.

WHERE (condition).....

If you wish to select only those records which meet specific criteria, you can add a conditional test next to any of the panel fields. This test can be a previously defined user name, or a number. The Period Number field accepts numeric values. All other entry fields accept only predefined user names.

Note: You can specify query criteria, regardless of the result format you select.