# Get list of ID's from table - push into array

**URL:** <https://community.tulip.co/t/get-list-of-ids-from-table-push-into-array/9713>\
**Category:** Support, Troubleshooting, & Help\
**Created:** [October 30, 2023, 11:18am UTC](https://community.tulip.co/t/get-list-of-ids-from-table-push-into-array/9713 "2023-10-30T11:18:35Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![danielpomeranz](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/danielpomeranz/32/9379_2.png) [@danielpomeranz](https://community.tulip.co/u/danielpomeranz)\
**Post date:** [October 30, 2023, 1:22pm UTC](https://community.tulip.co/t/get-list-of-ids-from-table-push-into-array/9713/2 "2023-10-30T13:22:28Z")

</div>

Hey Mark,

Tulip [Queries and Aggregations](https://support.tulip.co/docs/tulip-table-queries-and-aggregations) will unlock this for you.

You can add a query to a table named “All” which has no filters or anything on it. Then you can utilize a Unique Values aggregation on this query to get all the unique values in the ID column. Tulip apps will be able to utilize this aggregation just like an array variable. @John also put together [a tutorial here where you can see a more complex version of this](https://community.tulip.co/t/using-values-in-one-single-select-menu-to-dynamically-populate-values-in-a-second-single-select-menu-part-1/7251).

The only limitation worth noting is that the query and aggregation are limited to 1000 records. So there are situations where you will need to work around this. I do not imagine this is an immediate concern of yours.

Cheers.

---

_[View the full topic](https://community.tulip.co/t/get-list-of-ids-from-table-push-into-array/9713)._