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
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.
Procedure
The following describes how to use the Data Table diagram element to search for data and then process the data.
- Sign in to the AICC and choose .
- Configure an intelligent IVR flow.
- Choose and click New to add a simple flow.
- Click + in the Flow Variable area. In the dialog box that is displayed, set the variable name and data type.
- Save and publish the flow.
Figure 1 Flow variables to be added
Figure 2 Flow orchestration example (Data Table diagram element)
- Choose and bind the flow to a robot.
- Choose Start Call to test the robot.
. In the last column corresponding to the robot, click Test Call. In the test dialog box that is displayed, click
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot