4.10.3 Database Get Data

Once a Database Execute 251 action has been used, it may return 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.

In addition to the normal licenses for Voicemail Pro 22 , use of database actions requires the IP Office system to have an Advanced Edition license. For systems upgraded to IP Office Release 6, existing legacy VMPro Database Interface licenses can still be used.

Settings

1.Click the Database Actions icon and select Database Get Data.

2.The General 176 , Entry Prompts 177 , Reporting 182 and Results 183 tabs are standard tabs available to all actions.

3.Select the Specific tab. Chose which record should be selected by selecting one of the following options:

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.

Results

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

The Database Get Data action has four possible results.

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.

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 IVR Database Connection Example, Retrieving Data From the Database 366 .

Voicemail Pro Installation and Maintenance

Page 252

IP Office Release 6

15-601063 Issue 22e (16 May 2010)

Page 252
Image 252
Avaya 6 manual Database Get Data