DB Get Data List

This Database tool retrieves a list of call attributes and a parallel list of values from an CIC source. The query it executes is "Select * from Table Name Value Where Where Clause Value". CIC Data Sources are configured in Interaction Administrator.

This tool was created for use with the Interaction Dialer application that will read and write many call attributes to and from a data source. In most cases, you can use the Get Attribute tool to retrieve the value of a default or custom call attribute.

Inputs

IC Data Source

This must be an CIC Data Source (configured in Interaction Administrator) that refers to an ODBC DSN.

Table Name

The name of the table to query. This becomes part of the search criteria when this tool executes.

Where Clause

The row to query. For example, "Agent = 4". If you specify more than one row, only the first row is used.

Attribute Name Prefix

The characters to strip from the beginning of the attribute name before placing the attribute name in the Attribute Name output list. For example, if the attribute name is "IntDialer_Attribute1" and you specify "IntDialer_" as the prefix to remove, only "Attribute1" is listed in the output list. This parameter is optional.

Attribute Name Suffix

The characters to strip from the end of the attribute name before placing the attribute name in the Attribute Name output list. For example, if the attribute name is "Attribute1_IntDialer" and you specify "_IntDialer" as the suffix to remove, only "Attribute1" is listed in the output list. This parameter is optional.

Timeout

The number of seconds to wait for the operation to complete before taking the Failure exit path. Any value less than or equal to zero results in the default value of 60 seconds being used. You may specify a decimal value, such as 5.5.

Outputs

Attribute Names

The list of strings containing the attribute names retrieved.

Attribute Values

The list of values that parallels the list of Attribute names.

Exit Paths

Success

If the operation is successful, this tool takes the Success exit path.

Failure

This tool takes the Failure exit path if the syntax of the Where clause in incorrect, if the CIC Data Source is configured incorrectly, or if the Timeout value is exceeded.