Database Execute Action

Last Updated : Jul 15, 2021 |

The Database Execute action performs an SQL query on a database opened by the preceding Database Open action. An SQL query that is generated by the Database Execute action does not support spaces in the field or table names.

Procedure

  1. Click the Database Actions icon.
  2. Click on the callflow where you want the action placed.
  3. Connect the new action to the required result of a preceding action.
  4. Select Database Execute.
  5. Double-click on the action to display its settings tabs.
  6. The General, Entry Prompts, Reporting and Results tabs are standard tabs available to all actions. See The Start Action and Action Settings Tabs.
  7. Select the Specific tab. The SQL Wizard window opens. Use the wizard to construct the SQL query.

    • Any data included in the query must match the data type (number, integer or text) of the field that the query runs on. Values being used to query a text field should be enclosed by quotation marks. This applies whether using query values entered directly or using Voicemail Pro variables. For example, if using $KEY as a query value, for a text field query you must enter "$KEY".

  8. Click OK.
  9. Connect the action's results to following actions as required.

Result

This action has the following results which can be connected to further actions:

  • Success: The action has been successful and has returned a set of records from the database.

  • Failure: The action has not returned any data.

Example

For examples of the action in a call flow, see Retrieving Data From the Database and Entering Details in to the Database.

Related information
Database Actions