Help Center/ Cognitive Engagement Center/ User Guide/ Tenant Administrator Guide/ Robot Management and Configuration Guide/ Operator: Configuring a Common IVR/ Diagram Elements/ Data Table
Updated on 2024-10-12 GMT+08:00
View PDF
Share

Data Table

This diagram element is used to search for configuration data. It is used with the Branch Judgement diagram element to determine which branch to go to or the next step to process data.

Diagram Element

Parameter Description

  • Node Name: name of a node.
  • Description: details of a node.
  • Data Table Name: name of the data table to be searched.
  • Search Page: page number of the data table to be searched. Enter an integer or a variable. If this parameter is left blank, the first page is searched by default. The page size is fixed at 10.
  • Search Criteria: condition for searching a data table.
    • If the field is of the character type, the operator can be =, >, >=, <, <=, !=, like, or in. If the field value is of the character type, it does not need to be enclosed in quotation marks. If the operator is in and the field value is of the list type, each list item must be enclosed in double quotation marks, for example, ["watermelon","apple"].
    • If the field is of the integer type, the operator can be =, >, >=, <, <=, !=, or in.
    • If the field is of the date type, the operator can be =, >, >=, <, <=, or !=. Set Field Value to a timestamp, in milliseconds. A value or variable of the character type or long integer type is supported. A value or variable of the character type does not need to be enclosed in double quotation marks.
  • Return Records: variable for saving search results. Enter a variable of the list type.
  • Total: variable for saving the total number of search results. Enter a variable of the integer type.

Condition Branch Description

Table 1 Condition branch description

Condition Branch

Description

Usage

SYSERROR_INNER

ODFS internal error

Triggered when an unknown error occurs in the ODFS. If no option is selected, the flow goes to the exception handling flow.

Using the Diagram Element

The Data Table diagram element is used when you need to search a customized data table for data.

Click the diagram element or drag it to the canvas. Select a data table and add search conditions.

Typical Application Scenario

Use the Data Table diagram element in an IVR flow to search for the milk brand, price, and inventory.

Prerequisites

You have added a data table by referring to Adding Data Tables.

Procedure

The following describes how to use the Data Table diagram element to search for data and then process the data.

  1. Sign in to the AICC and choose Configuration Center > Chatbot Management > Flow Configuration.
  2. Configure an intelligent IVR flow.

    1. Choose Flow > Orchestration and click New to add a simple flow.
    2. Click + in the Flow Variable area. In the dialog box that is displayed, set the variable name and data type.
    3. Save and publish the flow.
      Figure 1 Flow variables to be added
      Figure 2 Flow orchestration example (Data Table diagram element)

  3. Choose Intelligent Chatbot and bind the flow to a robot.
  4. Choose Intelligent Chatbot. In the last column corresponding to the robot, click Test Call. In the test dialog box that is displayed, click Start Call to test the robot.

Parent topic: Diagram Elements