Field Selection tab (DB Read step)

Use the Field Selection tab of the DB Read customizer window to define the SQL SELECT statement required to retrieve the data that you need from the specified database.

DB Read Customizer Window—Field Selection Tab

The following table describes the properties of the Field Selection tab of the DB Read customizer window:

DB Read Properties—SQL Tab

Properties / Buttons

Description

Enter SQL command to be executed

SQL command that you want to be executed, using standard SQL syntax.

Note	The SQL statements SELECT count() and SELECT min() are not supported.

Test (button)

Click this button to test your query and connectivity to the chosen database.

Note	To test the SQL statement, you must have a connection to an active Cisco Unified CCX Engine.

Number of rows returned

Display only. Populates when the Test button is clicked.

Note	Use this value to determine whether or not your query is working correctly.

Show All Fields (Select Table/View)

Displays fields defined in a particular table in this database.