Contents

Update Column Dialog

This dialog identifies which column (field) will be updated by DB Update, and the data that will be assigned to the field.

Column to update field

Identifies which field that will be updated in the table. The remaining options on this dialog define the data to place in the field.

This string value

Assigns alphanumeric data to the column.

This numeric value

Assigns numeric data to the column updated.

This boolean value

Assigns a value of True or False to the column updated.

This call attribute

Assigns one of the following call attributes to the column updated:

ANI—the caller's telephone number.
Caller ID—the caller's name.
DNIS—the telephone number that was dialed.
Interaction ID Key—a unique ID number that identifies a call. This key is always unique, while Call ID number may not be.
Line Name—the CIC line name that the call came in on.

Data retrieved by the DB query at node

Allows you to assign the value returned by a DB Query to the column updated. The combo box is empty unless the server configuration contains at least one DB Query.

The value entered by the user at

This option assigns a string of data collected by a Caller Data Entry operation to the column updated.

The current date

Assigns the current date to the column updated. The date format is YYYY-MM-DD.

This date

Assigns any date that you select using a calendar field to the column updated.

The current date and time

Assigns the current date and time to the column in YYYY-MM-DD HH:MM:SS format.

This time

Assigns any date and time that you select to the column updated.

Ok button

Saves the selections that you have made and closes the dialog.

Cancel button

Closes the dialog without saving selections.

Related Topics