|
Submits a SQL (Structured Query Language) statement to a database server and returns a single result. |
Supported Script Types
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 waits 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 the 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.