Troubleshooting guide

118 Avaya CMS Supervisor Report Designer
Enter the SQL WHERE criteria window
Use this Query Assistant window to define the SQL WHERE clauses that you want to use
to retrieve data for the report. The SQL WHERE clause tells the CMS to retrieve the data
defined in the SELECT box that matches the criteria defined in the WHERE box. The
SELECT box specifies which columns of data to consider in the database tables. The
WHERE box species which rows of data to consider in the database tables.
Tips using this window
You can add your own text, such as parenthesis and numbers, in the WHERE clause by
placing your cursor where you want the text to display and typing in the text.
If you want to create a report that will display data for multiple splits/skills or VDNs on
multiple ACDs, you can enter MULTI_ACD in the WHERE clause, instead of entering each
individual OR statement. This will only work if you have correctly set up the inputs for the
multi-ACD report.