Lucent Technologies CentreVu Report Designer, Руководство пользователя

Страница: 113 / 266

Edit | Queries CentreVu Report Designer Version 8 User Guide
Creating a Real-Time or Historical Query
7-11
If you place “or” between clauses, then either of the clauses can be
true in order for CMS to retrieve the SELECT data from the table.
24. Repeat Steps 20 through 23 until you have completed the query.
You can add your own text in the WHERE clause (such as
parenthesis and numbers) by placing your cursor where you would
like the text to appear and then typing in the text.
If you are creating a report that will display data for multiple
splits/skills or VDNs on multiple ACDs, you can type 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. See Chapter 6, “Edit | Inputs,” for information on
setting up the inputs for a multi-ACD report.
25. Select the Test button.
CMS checks the syntax of the query and returns a message with
any errors.
For information on the most common query errors, see Chapter 16,
“Error Messages,” in this document.
Note that some errors are not detected until you run the report.
26. Correct any of the errors detected in the Test.
27. Select the Next button.
The Query Assistant “Enter a name for this query” window appears:
28. In the Name text box, type the name that you would like to assign to
the query you created.
29. Select the Done button.