Troubleshooting guide

112 Avaya CMS Supervisor Report Designer
About queries
To complete the definition of a report's tables, charts, or fields, you must define the queries
that select the rows of the appropriate tables in the CMS database.
This section includes the following topics:
● What are queries? on page 112
● About columns and rows on page 112
What are queries?
Queries are values for either database items or calculations. In most cases, the queries
specify the input variables, rather than specific values, as criteria to retrieve information
from the database. The input variables allow CMS to use the values entered in the Report
Input window as the query criteria for the report.
If you change the prompt in the Edit Inputs window, it is automatically updated in the
query.
Queries provide the CMS server with the following information:
● Where to get the data
● How to use the data
About columns and rows
CMS selects values from a table with both row and column identifiers. CMS identifies rows
of data according to the user's inputs and the row search conditions you define. CMS
identifies columns according to the data expression you define.
Related topics
For more information, see the Avaya CMS Database Items and Calculations document.