Troubleshooting guide

February 2006 111
Chapter 6: Edit | Queries
This section describes the Edit | Queries menu option.
A report consists of fields, charts, and grids that display data that is retrieved from the
Avaya Call Management System (CMS) database tables. Use a query to define what data
is retrieved for a specific report.
Organization of general information
This section includes the following general information:
● About queries on page 112
● The Query Assistant window on page 113
● Select a database and one or more tables for the query window on page 115
● Add the database items and calculations for the SELECT portion of the query
window on page 116
● Choose functions for the SELECT items window on page 117
● Enter the SQL WHERE criteria window on page 118
● Specify all field joins for the tables window on page 120
Organization of procedures
This section includes the following procedures:
● Create a new query for a real-time report on page 121
● Create a new query for a historical report on page 123
● Create a new query for an integrated report on page 126
● Edit an existing real-time or historical query on page 128
● Edit an existing integrated query on page 130
● Copy a query on page 131
● Delete a query on page 132