Voicemail Pro call flows can interact with PostgreSQL databases. The Database Actions that can be used in a call flow are:
|
Action
|
Description
|
|
Database Open
|
Opens the required database, including any permissions and security options.
|
|
Database Execute
|
Defines a SQL query to either read matching records from the database or to write data to the database. Up to 6 fields matching database records can be returned.
|
|
Database Get Data
|
Selects the current record from the matches returned by the preceding Database Execute action. The record fields are then placed into Voicemail Pro variables $DBD[0] to $DBD[5]. Use the Database Get Data to select the first, next, previous, or last record.
|
|
Database Close
|
Closes the database connection. This also occurs automatically if the caller disconnects.
|
