Adtran 619510003-1A User Manual
Enterprise Communications Server
Using Database Elements
619510003-1A
Copyright © 2009 ADTRAN, Inc.
167
For example, assume that you have a data source with a Date field, and that each row in the data source has
a unique date value. If the data source defines a sort order based on this Date field and descending order,
then any Dial for Data element that fetches from the data source will retrieve rows in descending date
order. If a Dial for Data element fetches multiple rows, then the first row will be the row in the fetched set
of records with the newest value in the Date field. Thus another element referencing this Dial for Data
element would always reference the newest row. Without the sort, you cannot predict which row in the
retrieved set would be first.
a unique date value. If the data source defines a sort order based on this Date field and descending order,
then any Dial for Data element that fetches from the data source will retrieve rows in descending date
order. If a Dial for Data element fetches multiple rows, then the first row will be the row in the fetched set
of records with the newest value in the Date field. Thus another element referencing this Dial for Data
element would always reference the newest row. Without the sort, you cannot predict which row in the
retrieved set would be first.
Selecting a row of data
When a Dial for Data element fetches one or many rows, the first row becomes the current row. The order
of the rows is determined by the sorting modes selected, as described above.
of the rows is determined by the sorting modes selected, as described above.
Other elements can refer to fields fetched by the Dial for Data element. These elements reference the value
in the current row. A different current row can be selected, using the
in the current row. A different current row can be selected, using the
. For information about specifying data sources,
filter fields, and values, refer to
Add Data element
The Add Data element allows callers to add to the data in a specified data source. The Record
Announcement element can be used to record temporary recordings, which can be used with the Add Data
element as a form filling application, in order to request quotes, have callers answer general customer
service questions, and so on. For more information on temporary recordings, refer to
Announcement element can be used to record temporary recordings, which can be used with the Add Data
element as a form filling application, in order to request quotes, have callers answer general customer
service questions, and so on. For more information on temporary recordings, refer to
• If the data is added successfully, the caller exits the regular connector pin.
• If the data is not added successfully, for any reason, the caller exits the Otherwise connector pin.
• If the data is not added successfully, for any reason, the caller exits the Otherwise connector pin.
You can put a Play Announcement element before a Dial for Data element to give the
caller instructions about how to use the feature.
caller instructions about how to use the feature.
Add Data element