Query Record List from Data Table
Parameter Configuration
| Parameter | Description |
|---|---|
| Data Table | The data table to query from |
| Filter | Filter conditions for querying data. Filter values can be dynamically specified using expressions |
| Page Size | Number of records returned per page. Page size can be dynamically specified using expressions |
| Page Number | Query data page number. Page number can be dynamically specified using expressions |
| Aggregation Query | Whether to enable aggregation query. After enabling, you can set the aggregation method and grouping columns used for aggregation calculation |
| Return Field List | The list of fields to return in the records. If not set, all fields will be returned |
| Return Option Display Names | Whether to return display values for List Selection, Tree Selection, and Cascading Selection in the returned records |
| Sort Fields | Combination of sort fields for the query result |
| Aggregation Columns | List of aggregated fields and aggregation methods after enabling aggregation query |
| Group By Fields | List of grouping fields for aggregation after enabling aggregation query |
| Separate Multi-select Values | For multi-select grouping fields, whether to merge the same elements from multiple records into the same record |
Return Value
| Return Value | Type | Description |
|---|---|---|
| Record List | Array<Record> | Record list queried according to step settings |
Notes
- Page Number, a maximum of 100,000 records can be queried at a time. For single pages exceeding this limit, you need to use Query Record Count to get the total number of records, then query multiple times with pagination
- Return Field List, when returning too many records at once, the return field list needs to be carefully controlled to avoid the risk of memory overflow
Usage Scenarios
- Query data from the data table with specified conditions for use in subsequent steps
- Query data from the data table with specified conditions and return it or return it to the API
Usage Examples
Assuming a Task Management (task) data table:
| Field | Type | Description |
|---|---|---|
| taskNo | Single Line Text | Task number |
| name | Single Line Text | Task name |
| owner | User Selection | Task owner |
| status | List Selection | Task status Not Started notstarted In Progress progress Completed complete Canceled canceled |
- Query Task List