Troubleshooting guide

122 Avaya CMS Supervisor Report Designer
16. In the Operand2 box, highlight the second database item or calculation that you want
considered in the WHERE clause.
Example: If you wanted the report to select the data from the table when the number
of ACDCALLS is greater than the number of ACWINCALLS, you would select
acdcalls in the Operand1 box, the > sign in the Operator box, and ACWINCALLS in
the Operand2 box.
17. Select AND or OR, as appropriate.
18. Repeat Steps 14 through 17 until you have completed the query.
19. Select Test.
CMS checks the syntax of the query and returns a message with any errors. For more
information, see Appendix A:
Error messages on page 217.
20. Correct any of the errors detected in the test.
21. Select Next.
A Query Assistant window is displayed. Use this window to give your query a new
name.
22. In the Name text box, enter the name that you want to assign to the query you created.
23. Select Done.