Advanced Report Design
CentreVu CMS Custom Reports
Alternative Row Search Conditions
6-31
The question mark (
?
) matches any single character. Look at the following
examples:
Select rows where: EXTENSION matches ’444?’
This clause finds all rows where the EXTENSION value is four digits and has
444 as the first three characters. Thus, 4441, 4440, and 4449 would match.
However, 444 would not match.
Select rows where: LOGID matches ’?000’
This clause finds all rows where the LOGID value is four digits, begins with
any number, and ends with “000.” Thus, 4000, 5000, and 9000 would match.
000 would not match.
You can use
not
in a “matches” clause to exclude rows. For example, you
may want to exclude a range of login IDs from your report with a clause like
the following:
Select rows where: LOGID not matches ’2*’
This clause finds all login IDs except those starting with “2.” If you have 4-
digit login IDs, login IDs from 2000 to 2999 would be excluded.
Using
String-Value
Database
Items
6
String-value database items contain numerical data that the Dictionary
subsystem translates to display current states or state changes. For
example, a report field using the string-value database item WORKMODE
displays AVAIL, ACD, ACW, and so on, depending on what state the
particular agent is currently in. However, tables store states as numbers, not
strings. When you run a report,
CentreVu CMS simply substitutes the
character strings for the numerical values. This process is identical to the
substitution of names for split numbers, trunk group numbers, vectors, and
so on.
If you want to use string-value database items in a “where” clause, then you
must specify numerical values, not string values.
For example, if you want a current real-time agent report that lists data only
for agents on extension-in or extension-out calls, then you can select the
Current Interval Agent table and enter a statement as follows:
Select rows where: SPLIT = $splitvar and WORKMODE >
10 and WORKMODE < 60
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: ......
