> For the complete documentation index, see [llms.txt](https://docs.coreway.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.coreway.com/coreway-table/automation/data-nodes/get-multiple-records.md).

# 獲取多條數據

### 1. 節點功能

在主流程裡添加此節點後，可以按條件獲取到多條記錄數據；此後可以對這些記錄數據進行批量新增到他表、刪除、修改，或供後續流程中的其他節點使用。

### 2. 獲取方式

![image.png](https://273888574-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F9WI4IMScYYFwRQSZY8Zr%2Fuploads%2FYMQ043JuKz1H1alqyYPN%2F17682567319705.png?alt=media)

* **從工作表獲取記錄**：獲取的多條數據可供本流程的數據處理節點或子流程節點使用。
* **從記錄獲取關聯記錄**：獲取的多條數據可供本流程的數據處理節點或子流程節點使用。被數據處理節點（新增、更新、刪除）使用時，最多支持 100 條；被子流程節點使用時，最多支持 1 萬條。

  > 註：此方式最多獲取 1000 條關聯記錄，如果需要獲取更多數據，請使用「從工作表獲取記錄」的方式。

### 3. 節點設置

#### 3.1 從工作表獲取記錄

**3.1.1 為主記錄添加獲取多條數據節點**

![image.png](https://273888574-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F9WI4IMScYYFwRQSZY8Zr%2Fuploads%2F31q9AhMlJRp5Ngn8Gz1j%2F17683287970329.png?alt=media)

**3.1.2 配置節點**

![image.png](https://273888574-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F9WI4IMScYYFwRQSZY8Zr%2Fuploads%2FbDkmEysmypncymW6BJ2Q%2F17683565053337.png?alt=media)

需要設置 4 項內容：

* **選擇工作表**：選擇從哪張工作表中查找數據
* **篩選條件**：設置查找的條件
* **排序規則**：設置獲取哪個排序規則下的多條數據
* **獲取數據條數上限**：設置最大獲取條數，如輸入 20，則只獲取 20 條記錄

配置過程與「獲取單條數據」節點一樣，請參考「獲取單條數據」。

#### 3.2 從記錄獲取關聯記錄

**3.2.1 為主記錄添加獲取多條數據節點**

![image.png](https://273888574-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F9WI4IMScYYFwRQSZY8Zr%2Fuploads%2FoJSg8Kxf5XIqcvmLy3l5%2F17683227752089.png?alt=media)

**3.2.2 配置節點**

![image.png](https://273888574-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F9WI4IMScYYFwRQSZY8Zr%2Fuploads%2FlZs2PkSuW3b8GRTVW1pP%2F17683366053785.png?alt=media)

需要設置 4 項內容：

* **選擇工作表**：選擇從哪張工作表中查找數據
* **篩選條件**：設置查找的條件
* **排序規則**：設置獲取哪個排序規則下的多條數據
* **獲取數據條數上限**：設置最大獲取條數

**3.2.3 限制數量**

* 可以手動輸入一個固定數值，作為獲取的數據條數。
* 例如查詢時，滿足條件的記錄有 100 條，但只需用 50 條，就可以輸入 50 條。
* 如果自定義數量，獲取多條數據節點最多只能獲取到 100 條；如果傳給子流程用，最多獲取 1 萬條。
* 如果被新增數據、更新數據、刪除數據等 3 個節點使用時，建議輸入最多獲取 100 條，避免報錯。
* 如果需要傳給子流程，建議設置最多 1 萬條，避免報錯。


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.coreway.com/coreway-table/automation/data-nodes/get-multiple-records.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
