Select Record

The Select Record Node is used to populate Custom Service Variables with data that has been stored in a Data Table record. A record is selected from the data table using the 'Lookup Value' specified in this node to match against the predefined Data Table Key Field. If you are new to Data Tables, please see Managing Data Tables for a better understanding of Data Table records and the importance of the Data Table Key Field.

Branch Name	Mandatory	Description
Success	Yes	Taken when a record was successfully found that matched the Lookup Value and the configured custom service variables have been populated with the Data Table record field data.
Record Not Found	Yes	Taken when the Data Table did not contain a record that matched the configured Lookup Value.
Field Not Found	Yes	Taken when a record was found but a field configured as a "Must Find Field" was not found in the selected record.
Failed	Yes	This branch is taken in the unlikely event that an unexpected platform issue occurred while attempting to access the Data Table.

A record is selected where the Data Table Key Field contains a value that matches the value specified in the Lookup Value. In the example below, the platform will search the Data Table for a record where the Key Field named 'ServiceNumber' has a value of '01132265408'. If a record is found, the variable '@Destination' will be assigned the value stored in the field named 'Destination' and the variable '@RingDuration' will be assigned the value stored in the field named 'RingDuration'

Node Properties

The Node Properties is where you to define which fields you want to select and read into Custom Service Variables.

The first step is to choose the Data Table using the magnifying glass icon. Once this has been done the name of the Key Field for that Data Table is shown. The second step is to enter the value you want to use in the Lookup Value field or select a variable that contains the information. The next step is to specify the variables you wish to populate with values from the Data Table this is done as follows: Press the [Add New] button to add to the field selection configuration. The dialog box below will be shown:-

The Field Name drop down list will only contain values when the Data Table contains some records.

This list is initially populated with the fields found in the first 10 records in the Data Table. Pressing the [Refresh Fields] button will force a full scan of all the Data Table records.

Field Names are not restricted to the values in the drop down list and can be entered manually.

Must find Field

Data Table records are flexible and do not need to have the same fields defined for each record.

The Must Find Field setting allows you to control the call flow where a record has successfully been found in the Data Table but the record did not contain the required field.

The Field Not Found branch will be taken when the Must Find Field is set to 'Yes' and the specified field name was not found in the selected record.

Viewing Logs

Once the node has been used in a call plan pressing the View Log button on the Node Settings screen will show the latest audit logs that have been generated by the node for inbound calls.