Cisco Cisco IPCC Web Option User Guide

Figure 38: DB Lookup Properties

Define 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 defined in ICM software.)

Note: Define all integer fields 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 (float), and SQLDATETIME (datetime).
All fields except SQLDATETIME, SQLVARCHAR, and SQLCHAR must be defined as
NOT NULL fields. These three fields can be defined as NULL.

2. In the Lookup value field, define 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 field
in the table. You can use formulas to define the expression. For example, if phone_number
is a key field 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:

Scripting and Media Routing Guide Cisco Unified ICM/Contact Center Enterprise & Hosted Release 7.5(1)