Sqlselect

Submits an SQL (Structured Query Language) statement to a database server and returns a single result.

Supported Script Types

Generic Email Chat Phone Voicemail Work Item SMS

Properties

Property Details
SQLQuery The SQL statement that will be submitted to the database server. This statement should be expected to return records.
GlobalVariables Not used.
Publish

Publishes a variable and value.

This property publishes everything in the database associated with a contact.

If you want to publish specific data, use the Assign action.

TimeoutSec The amount of seconds that the action will wait to execute before timing out. The value must be between 0 and 60.

Branches

Branch Details

Default

Path taken unless the script meets a condition that requires it to take one of the other branches. It is also taken if the other branches are not defined.
NoRecords Path taken if there are no values for the specified properties. This happens when data is not returned from the database.
OnError Path taken when an action fails to execute properly.
OnTimeout Path taken if there is no response for the number of seconds specified.

Tips & Tricks

  • Use a Sqlcursor action when multiple row results are required.
  • A query typically returns one or more columns of data. When CXone returns the data from the database server back to the script, each individual column is stored in a variable with the same name.
  • You will need to determine if you want a standard, encrypted, or VPN connection to your DB Provider. Unless otherwise specified in a Setdb action, CXone will use the default CXone database. This database is a generic dictionary of tables provided to all customers.