SQL Query and CMS Database Table Basics
CentreVu Report Designer Version 8 User Guide
About SQL Queries
18-3
When you run the report,
CentreVu® CMS finds the row in the table (see
the following figure) for Split 5 and fills in the report fields with data from
that row (in bold in the figure).
Thus, the report fields show the following data:
Split: 5
ACD Calls: 451
Average Talk Time: 61 (the result of 27635/451
)
This example of row search criteria would also include the selection of an
ACD. See “
WHERE Clause for Selecting Rows from an ACD
” later in this
section.
WHERE Clause
with Variable
18
The previous examples create hard coded row search conditions. That
is, when you run the report,
CentreVu CMS always searches for the
values you entered in the WHERE clause. However, instead of a hard
coded value, you can enter a variable name in a clause. A variable
name tells
CentreVu CMS to search for whatever value(s) you or another
user choose when you run the report. You must define a variable on the
Define Input window before using it in a WHERE clause. The variable
name then links a report input field to the WHERE clause that uses the
value(s) entered.
5
4
3
2
9
8
789
10
203
603
851
245
644
1058
400
777
988
..
..
.
.
..
.
.
.
..
.
.
.
..
.
.
.
..
.
.
.
..
.
.
.
..
.
.
.
..
.
.
.
..
.
.
.
..
.
.
.
..
.
.
.
..
.
.
.
..
.
.
.
..
.
.
.
..
.
.
.
..
.
.
.
..
.
.
.
..
.
.
.
..
.
.
.
..
.
.
.
..
.
.
.
..
.
.
.
..
.
.
.
..
.
.
.
..
.
.
.
..
.
.
.
..
.
.
.
..
.
.
.
..
.
.
.
..
..
ACDTIME
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
33389
9786
19768
35401
15321
27635
53442
13111
20012
36898
ABANDONS
39
10
31
43
11
32
59
20
37
48
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
ACDCALLS
SPLIT
480
142
391
509
93
451
652
111
234
443
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
..
..
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
ABNTIME
1
7
6
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
Содержание CentreVu Report Designer
Страница 1: ...CentreVu Report Designer Version 8 User Guide 585 210 930 Comcode 108502196 Issue 1 December 1999...
Страница 4: ......
Страница 18: ...Introduction CentreVu Report Designer Version 8 User Guide Related Documents 1 8...
Страница 102: ...Edit Inputs CentreVu Report Designer Version 8 User Guide Viewing the Input Window 6 16...
Страница 142: ...Insert Field CentreVu Report Designer Version 8 User Guide Inserting Time Report Run Field on the Report 9 8...
Страница 148: ...Insert Table CentreVu Report Designer Version 8 User Guide Inserting a Table on the Report 10 6...
Страница 194: ...Format Field CentreVu Report Designer Version 8 User Guide Using the Field Format Options Window 14 6...
Страница 198: ...Format Text CentreVu Report Designer Version 8 User Guide Formatting Text on the Report 15 4...
Страница 212: ...Error Messages CentreVu Report Designer Version 8 User Guide Phase 2 Real Time Report Error Codes 16 14...
Страница 248: ...SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide Modifying a Table 18 26...
Страница 254: ...Database Items and Calculations CentreVu Report Designer Version 8 User Guide General Information B 2...
Страница 264: ...Index CentreVu CMS R3V8 Upgrades and Migration IN 10...
Страница 266: ......