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.
Summary of Contents for CentreVu Report Designer
Page 4: ......
Page 18: ...Introduction CentreVu Report Designer Version 8 User Guide Related Documents 1 8...
Page 102: ...Edit Inputs CentreVu Report Designer Version 8 User Guide Viewing the Input Window 6 16...
Page 198: ...Format Text CentreVu Report Designer Version 8 User Guide Formatting Text on the Report 15 4...
Page 264: ...Index CentreVu CMS R3V8 Upgrades and Migration IN 10...
Page 266: ......