Edit | Inputs
CentreVu Report Designer Version 8 User Guide
Adding Input Fields to the Input Window
6-7
If you are defining an integrated report, you cannot and do not need to
define a “Start Time” input field because the field is automatically included
in the Report Input window.
Input Fields That
Allow Pattern
Matching
6
CMS can search for values in certain database items according to wild
card search patterns. As a result, you can create a report that allows
inputs based on character strings, plus either an asterisk (matches on
blank and all characters) or a question mark (matches on any single
character).
CMS then includes data for all items that match the character
strings the user entered.
The standard database items that allow this type of searching are as
follows:
●
VDN (the value is a VDN number)
●
EXTENSION (the value is an extension number)
●
LOGID (the value is an agent login ID)
●
EQLOC (the value is a 9-digit trunk location number)
●
CWC (the value is a call work code)
●
ROW_DATE
(the value is a date)
In addition, any custom database items that you define as CHAR
columns in
INFORMIX also allow this type of searching.
As an example of matching with an asterisk (*), if an input field were a
String
type and were associated with the LOGID database item, the
user could enter
1*
, and CMS would include data for all agents with
login IDs that start with 1 (1, 10, 1238, 190, and so on, depending on the
switch's administered login length). As an example of matching with a
question mark (?), if an input field were a
String
type and were
associated with the VDN database item, the user could enter
21?0
, and
CMS would include data for all VDNs that start with 21, end with 0, and
have any single character appearing between the 21 and the 0 (2100,
2110, 2120, 2130, and so on).
If you select
String
for an input field, CMS does not check a user's
inputs in that field for appropriate read permissions or valid switch
parameters. If you want CMS to check permissions for a VDN input field,
you must select the
VDN
field type. If you want CMS to check switch
parameters for a VDN, login ID, extension, or call work code input field,
you must select that field type, not
String
. In addition, if you select
String
for a field, the user will not be able to enter Dictionary names.
So, again, if you want to let the user enter VDN, login ID, or call work
code names to run a report, you must select that specific field type, not
String.
Содержание 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: ......