Troubleshooting guide

February 2006 99
In addition, any custom database items that you define as CHAR columns in the CMS
database also allow pattern matching.
Using an asterisk
You can search with an asterisk (*). If an input field is a string type and is associated with
the LOGID database item, the user can enter 1*, and CMS will report data for all agents
with login IDs that start with 1.
Using a question mark
You can search with a question mark (?). If an input field is a string type and is associated
with the VDN database item, the user can enter 21?0, and CMS will report data for all
VDNs that start with 21, end with 0, and have any single character appearing between the
21 and the 0, for example 2100, 2110, 2120, 2130, and so on.
Using String as an input field
If you select String for an input field, CMS does not check user inputs in that field for
appropriate read permissions or valid 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
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.