SqlQuery

Runs a SQL statement against a database connector source and returns a Dynamic Data object.

Dependencies

• The DB provider must be set up prior to use.
• The Setdb action does not need to be used prior to this action.

Supported Script Types

Generic	Email	Chat	Phone	Voicemail	Work Item	SMS

Properties

Property	Description
Add Caption	Enter a short phrase that uniquely identifies this action in the script. The caption appears on the script canvas under the action icon.
Group Name	The name of the database provider as configured by the NICE CXone administrator. This property is case sensitive. Enter the DB Provider name, not the Service name. The Service name is used when you set up your DB Provider.
SQL Statement	The SQL statement to be submitted to the database server. This statement should be expected to return records.
Start Record	The record from the query result set with which you want to start.
Max Records	The maximum number of records to retrieve. The default is 100.
Timeout	The number of seconds until the query times out. The default is 10. The maximum number of seconds supported is 30 (though larger numbers can actually be entered in the field).

Output Properties

This action stores the resulting set of data in a Dynamic Data object. Each data object will be unique, based on the query and the amount of data returned.

Property	Description
Result (out)	This is the name of the Dynamic Data object that you want the data to be stored in.

Result Branch Conditions

Result branch conditions allow you to create branches in your script to handle different outcomes when an action executes.

Condition	Description
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 action's other branches are not defined.
OnNoRecords	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 the action fails to execute properly. For example, when there is an unexpected problem such as poor connectivity, syntax errors, and so on. The _ERR variable, with a single underscore character, should be populated with a condensed explanation of the problem. This happens when the SQL query is invalid.
OnTimeout	Path taken if there is no response for the number of seconds specified.