- Scenario Builder Reference Guide Introduction
- Scenario Builder OverviewExercises
- Scenario-Building ExercisesScenario Blocks Definitions
- Scenario BlocksReference
- Scenario Reference Material
- Add to Calling List
- Ask a Bot
- Attached Data
- AWS Lambda
- Bright Pattern Create Object
- Bright Pattern Delete Object
- Bright Pattern Search Object
- Bright Pattern Update Object
- Chat Bot Select Account
- Collect Digits
- Connect Call
- Connect Chat
- DB Execute
- Exception Handler
- External Transfer Call
- Fetch URL
- Find Agent
- Get Agent State
- Get Next Record
- Get Statistics
- Get User Configuration
- Identify Contact
- Internal Message
- Microsoft Dynamics Create Object
- Microsoft Dynamics Delete Object
- Microsoft Dynamics Screen Pop
- Microsoft Dynamics Search Object
- Microsoft Dynamics Select Account
- Microsoft Dynamics Update Object
- Play Prompt
- Request Callback
- Request Input
- Request Skill or Service
- Retrieve Internal Record
- RightNow Create Object
- RightNow Screen Pop
- RightNow Search
- RightNow Select Account
- RightNow Update
- Salesforce.com Delete
- Salesforce.com Insert
- Salesforce.com Screenpop
- Salesforce.com Search
- Salesforce.com Select Account
- Salesforce.com Update
- Save Survey Response
- Search Directory
- Self-Service Provided
- Send Message
- ServiceNow Create Object
- ServiceNow Screen Pop
- ServiceNow Search
- ServiceNow Select Account
- ServiceNow Update Object
- Set Agent State
- Set Case
- Set Custom Reporting Field
- Set Disposition
- Set Priority
- Set Prompt Language
- Set Variable
- Start Another Scenario
- Stop Prompt
- Web Screen Pop
- Zendesk API Request
- Zendesk Create Object
- Zendesk Screen Pop
- Zendesk Search
- Zendesk Select Account
- Zendesk Update Object
The DB Execute scenario block provides a way for a scenario to execute SQL statements on a specified database. This block can be used to share data between scenarios.
The DB Execute block may take one of the following conditional exits: Failed or No Data.
An error occurred during SQL statement execution. No error details are provided.
The SELECT statement successfully executed but did not return any records.
Title text is the name of the instance of the block. Enter a name in the text field and click the Update button at the bottom of the Edit pane. The new name of the block appears in the flowchart.
DB connection represents the desired database connection. See the other settings for details.
This is the name of the database connection. This name is shown in the DB Execute block connection selection menu. If no options are shown, click Manage DB connections to add new DB connections.
JDBC driver and connection string
Specify the JDBC driver and connection string that will be used to access this database. Note that templates are provided for some widely used DBMS systems.
Database user name and password
Specify database access credentials.
The database connection selector allows the following operations:
- Add a new connection (Add New button).
- Edit and save the selected connection (Save button).
- Delete the selected connection (Delete button).
- Select the connection to be used in the DB Execute block (Select button).
- Clear the connection selected for the DB Execute block (Select None button).
- Close the window without changing the DB Execute block connection (Close button).
This is the SQL statement to be executed. SQL statements may use scenario variables. For example: SELECT id, name FROM customers WHERE phone=’$(item.from)’
For SELECT statements, the name of the retrieved recordset should be specified. This allows scenarios to have more than one recordset and to choose the recordset to iterate on.
- The columns of the first retrieved record (if any) are stored in the scenario variables <recordset_name>.<column_name> (e.g., RS.id).
- The number of returned records is stored in variable <recordset_name>.__count__ (e.g., RS.__count__). Note the double underscores in front and after count; they are used to reduce the chance of confusing the name of this variable with a column name in a recordset.
- To iterate through the recordset, use the Get Next Record block.
- The number of records in the retrieved recordset is limited to 25.
The database connection is selected from a list of connections. Click the Manage DB connections button. The pop-up window will display all database connections defined in this scenario. For each connection, the following data should be defined: