Query Record List of Related List Field from Data Table
Parameter Configuration
| Parameter | Description |
|---|---|
| Data Table | The data table to query |
| Related Field | Related List field |
| Record ID | The ID of the record to query. Record ID can be dynamically specified using expressions |
| 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 aggregation query, you can set the aggregation method and the grouping columns used for aggregation calculation |
| Return Field List | List of record fields to return. All fields are returned if not set |
| Sort Field | Sort field for query result |
| Aggregation Columns | After enabling aggregation query, the list of aggregation fields and aggregation methods |
| Group By Fields | After enabling aggregation query, the list of grouping fields based on aggregation |
| Separate Multi-select Values | For multi-select grouping fields, whether to merge the same elements in multiple records into one record |
Return Value
| Return Value | Type | Description |
|---|---|---|
| Record List | Array<Record> | Record list that matches the settings for the Related List field |
Notes
- Page Number: A maximum of 100,000 records can be queried at a time. If the number exceeds this limit, you need to obtain the total number of records through Query Related List Record Count and query multiple times in pages
- Return Field List: When returning too many records at a time, the return field list needs to be carefully controlled to avoid memory overflow risk
Usage Scenarios
- Query data that meets filtering conditions for a specified record in the data table for use in subsequent steps
- Query data that meets filtering conditions for a specified record in the data table and return it or return it to the API