Defining the Data for a Custom Report
CentreVu CMS Custom Reports
Defining the Rows of Data for a Report
4-45
“Where” Clause
with a
Range/List
Variable
4
If a variable name, as defined in the Define Input window, has been assigned
the Range/list option, your “where” clause must use the equals sign (=) with
the variable name.
“Where” Clause
for Selecting
Rows from an
ACD
4
In your “where” statement, you must always include a clause to select the
ACD. If you always want a report to find data for the user's current ACD,
append
and ACD = $acd
to the “where” statement, as shown in the
following example:
Select rows where: SPLIT = $splitvar and ROW_DATE =
$datevar and ACD = $acd
If you use the variable name
acd
, you do not need to define the variable in
the Define Input window.
CentreVu CMS always understands acd to be the
current ACD. However, if you wish, you can define a different variable name
for the
ACD
database item so the user can specify the desired ACD(s) when
ordering the report. You can also hardcode the ACD in a “where” clause, as
in the following example.
Select rows where: ACD = 1
“Where” Clause
for Excluding
Rows of Data
4
If you want to exclude Split 5 from the report, but include all other splits, you
might enter a “where” clause as follows:
Select rows where: SPLIT != 5
or
Select rows where: SPLIT <> 5
Содержание CentreVu
Страница 1: ...585 215 822 Comcode 108501867 Issue 2 December 1996 CentreVu Call Management System Custom Reports ...
Страница 16: ...Preface CentreVu CMS R3V5 Custom Reports Related Documents P 10 ...
Страница 44: ...Getting Started CentreVu CMS Custom Reports Deleting a Custom Report 2 10 ...
Страница 140: ...Completing Your Custom Report CentreVu CMS Custom Reports Running Custom Reports 5 22 ...
Страница 178: ...Database Items and Calculations CentreVu CMS Custom Reports General Information A 2 ...
Страница 188: ...Glossary CentreVu CMS Custom Reports GL 10 ...
Страница 198: ......