Submits an SQL (Structured Query Language) statement to a database server and returns a single result.
Supported Script Types
|SQLQuery||The SQL statement that will be submitted to the database server. This statement should be expected to return records.|
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.|
|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.