User Guide

Figure 38: DB Lookup Properties
Dene the DB Lookup node properties as follows:
1. Select the database Table you want to query. (The drop-down list contains the enterprise
names of all lookup tables dened in ICM software.)
Note: Dene all integer elds in tables accessed by a DBLookup node as NOT NULL.
Only the following data types are supported for SQL databases: SQLINT1 (tinyint),
SQLINT2 (smallint), SQLINT4 (int), SQLCHAR (char), SQLVARCHAR (varchar),
SQLFLT4DBFLT4 (real), SQLFLT8DBFLT8 (oat), and SQLDATETIME (datetime).
All elds except SQLDATETIME, SQLVARCHAR, and SQLCHAR must be dened as
NOT NULL elds. These three elds can be dened as NULL.
2. In the Lookup value eld, dene constant or expression to match the key value in the row
you want to retrieve. The value must be of the appropriate data type to match the key eld
in the table. You can use formulas to dene the expression. For example, if phone_number
is a key eld in the database table, you might use Call.CallingLineID as the Lookup Value.
3. Optionally, add comments and connection labels.
How to Reference Retrieved External Data
To access retrieved data, you use the following syntax in nodes that reference a column:
Database.table-name.column-name
Scripting and Media Routing Guide Cisco Unified ICM/Contact Center Enterprise & Hosted Release 7.5(1)
49
Chapter 3: Categorizing Contacts
Categorizing By External Data