Database Get Data Action

Last Updated : Jul 15, 2021 |

About this task

Once a Database Execute action has been used, it returns a set of records from the database. A Database Get Data action or actions are then used to select which record is the currently selected record whose values are placed into the call flow's $DBD variables.

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 Get Data.
  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. Set the options as required.

    Setting

    Description

    Retrieve the next item in the list

    Select the next record returned by the Database Execute action as the currently selected record.

    Retrieve the previous item in the list

    Select the previous record returned by the Database Execute action as the currently selected record.

    Retrieve the first item in the list

    Select the first record returned by the Database Execute action as the currently selected record.

    Retrieve the last item in the list

    Select the last record returned by the Database Execute action as the currently selected record.
  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 selected records values have successfully been assigned to the $DBD variables.

  • At End: There are no further records in the set of data.

  • Empty: The execute method returned no data, the $DBD variable contains no information.

  • Failure: There was a problem trying to retrieve the next data record, the $DBD variable contains no information.

Example

Examples of using the database actions are given in the IVR database Connection section. For an example of the action in a call flow, see Retrieving Data From the Database .

Related information
Database Actions