Troubleshooting guide

116 Avaya CMS Supervisor Report Designer
Add the database items and calculations for the
SELECT portion of the query window
Use this window to add and remove database items and calculations that you want
included in the query.
This section includes the following topics:
● Tas ks on page 116
● Database Items or Calculations on page 116
Tasks
Use the Query Assistant window to do the following tasks:
● Use Move Up and Move Down to change the order of the items in the Query Items
box.
● Remove an item from the list, highlight an item in the Query Items list, and then select
Remove.
● Edit an item in the Query Items box, highlight the item, and then select Edit. The Select
Edit window is displayed.
Example:
To create a custom calculation in the edit box, add callsoffered - to the abncalls item.
This changes the item to callsoffered - abncalls.
Database Items or Calculations
Enter the names of database items or calculations, strings, or constants that you want to
use in the query by typing them in the Other text box.
Example: If you want the report to include information that subtracts the quantity of one
database item from the quantity of another database item (for instance, ACDCALLS -
ACDAUXOUTCALLS), then enter a - in the Other text box and add it to the list of Query
Items. When you create the WHERE clause for the query, you can specify a calculation of
ACDCALLS - ACDAUXOUTCALLS for the report.
Note:
Note: Constants that have been defined in the Dictionary are listed in the
Calculations box in addition to the calculation.