Defining the Data for a Custom Report
CentreVu CMS Custom Reports
Defining Report Fields
4-14
Step 2: Define
the Field’s
Data
Expression
4
In the
Select
field (shown in
), enter a data expression to tell
CentreVu CMS two things:
●
What table column(s) should supply data to the field.
●
How to manipulate that data.
CentreVu CMS picks out values from a table with both row and column
identifiers.
CentreVu CMS identifies rows of data according to the user’s
inputs and the row search conditions you define (see the “
” section in this chapter).
CentreVu CMS identifies
columns according to the data expression you define here.
You can enter the following types of data expressions:
Database Items
4
A database item is the name of a column of data in a table, either standard or
custom. When you enter a database item, you must always add the name of
a table and a period (.) as a prefix. The format is as follows:
<table name>.<database item>
Examples:
dsplit.ACDCALLS
hagent.STARTTIME
ctkgrp.NUMINUSE
Standard database items
Standard database items are listed in the Dictionary subsystem as having all
upper-case letters (as in the preceding examples).
A standard database item can store:
●
Identifiers (for example,
SPLIT
,
VDN
,
LOGID
, and so on)
●
Timed data (for example,
ACDTIME
,
ABANTIME
,
AUXOUTIME
, and so
on)
●
Event counts (for example,
ACDCALLS
,
INTERFLOWCALLS
,
ABNCALLS
,
and so on)
●
For real-time and agent trace reports, current state data (for example,
WORKMODE
,
DURATION
,
NUMINUSE
, and so on).
Summary of Contents for CentreVu
Page 16: ...Preface CentreVu CMS R3V5 Custom Reports Related Documents P 10 ...
Page 44: ...Getting Started CentreVu CMS Custom Reports Deleting a Custom Report 2 10 ...
Page 140: ...Completing Your Custom Report CentreVu CMS Custom Reports Running Custom Reports 5 22 ...
Page 178: ...Database Items and Calculations CentreVu CMS Custom Reports General Information A 2 ...
Page 188: ...Glossary CentreVu CMS Custom Reports GL 10 ...
Page 198: ......