Data Table

Updated on 2025-01-23 GMT+08:00

View PDF

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.

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

Query data records with milkCount being greater than 10 from the milkInfo table. If the condition is not met, the robot returns a message indicating that no such data record is found. If the condition is met, the robot returns the total number of such data records, data records on the first page that meets the condition, and milkName of the first data record.

Prerequisites

You have added a data table by referring to Adding Data Tables, as shown in the following figure.

Figure 1 Table fields

Figure 2 Table data

Procedure

Sign in to the AICC and choose Configuration Center > Chatbot Management > Flow Configuration.
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 3 Flow variables to be added
  
  Figure 4 Example of data table diagram element configuration
  
  Figure 5 Example of branch judgment diagram element configuration
  
  Figure 6 Flow orchestration example
Choose Intelligent Chatbot and bind the flow to a robot.
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.

NOTE:

Only 10 data records on the specified search page are queried. If no search criteria are specified, the first page is queried by default.