# How to retrieve workflow information

**URL:** <https://community.temporal.io/t/how-to-retrieve-workflow-information/15950>\
**Category:** Community Support\
**Created:** [January 3, 2025, 1:48pm UTC](https://community.temporal.io/t/how-to-retrieve-workflow-information/15950 "2025-01-03T13:48:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rosicleia](https://avatars.discourse-cdn.com/v4/letter/r/ed8c4c/32.png) [@Rosicleia](https://community.temporal.io/u/Rosicleia)\
**Post date:** [January 3, 2025, 1:48pm UTC](https://community.temporal.io/t/how-to-retrieve-workflow-information/15950/1 "2025-01-03T13:48:10Z")

</div>

I am evaluating the use of Temporal, and from the documentation, I couldn’t find a way to extract large amounts of records filtered by status.  
For example, I have 900k workflows with errors in the `receive confirmation` task and need to extract the workflow IDs for these 900k workflows. I read that the UI has limitations on the number of records. What method can be used to extract this information?

 ![Emissão, reemissão e internalização de cartão (6)](https://us1.discourse-cdn.com/flex016/uploads/temporal/original/2X/8/82d06e8a0c2d6db1bbda6e65883d9bb9000c5c0c.png)

---

<div class="post-metadata">

**Author:** ![maxim](https://sea2.discourse-cdn.com/flex016/user_avatar/community.temporal.io/maxim/32/8_2.png) [@maxim](https://community.temporal.io/u/maxim)\
**Post date:** [January 3, 2025, 7:09pm UTC](https://community.temporal.io/t/how-to-retrieve-workflow-information/15950/2 "2025-01-03T19:09:37Z")

</div>

You can use API or CLI to paginate over large list results. I doubt that you need to paginate through all 900k workflows in UI.

You can also consider using an external DB to keep these records. Insert them from the workflow using activities.

---

<div class="post-metadata">

**Author:** ![Rosicleia](https://avatars.discourse-cdn.com/v4/letter/r/ed8c4c/32.png) [@Rosicleia](https://community.temporal.io/u/Rosicleia)\
**Post date:** [January 6, 2025, 12:31pm UTC](https://community.temporal.io/t/how-to-retrieve-workflow-information/15950/3 "2025-01-06T12:31:40Z")

</div>

I had already thought about an external database.  
Thank you for your response.