Page tree
Skip to end of metadata
Go to start of metadata

In the following example you can learn how to build a DB interaction between the IVR application and a remote DataBase.

Here we imagine to make a SELECT FROM WHERE Sql statement inside a post call handling routine using the Finally Box.

First of all you let’s define a new Channel variable inside the project dashboard.


Then we need to declare a connection to an existing DB

DB 2

In our example we would need to query the table below (tableX):


DB Edit

The query we have performed is:

SELECT field1, field2, field3 FROM tableX

The whole returned resultset is stored in the RESULTSET defined variable.

To retrieve the value of a single field in a row you have to use the following notation (in our example by a NoOp box)


e.g the value of field1 will be store into RESULTSET[0][field1]


#row: the row number in the resultset. Note that the row numbering start from 0

field_name: the name of the column as named in the DB schema

  • No labels