Database connection

Last Updated : Jan 23, 2023 |

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.