# Large dataset filtering from custom data

**URL:** <https://forum.inductiveautomation.com/t/large-dataset-filtering-from-custom-data/90478>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [May 16, 2024, 8:33am UTC](https://forum.inductiveautomation.com/t/large-dataset-filtering-from-custom-data/90478 "2024-05-16T08:33:23Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alejandro\_Alaco](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/alejandro_alaco/32/59849_2.png) [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\
**Post date:** [May 16, 2024, 8:33am UTC](https://forum.inductiveautomation.com/t/large-dataset-filtering-from-custom-data/90478/1 "2024-05-16T08:33:23Z")

</div>

Hello!

I do have a large dataset I need to aply filters to with a filter panel:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/b/fb26663cf03676a9bad94911d98abcbf8ccd190f.png)

When I load the data as custom data so I can aply checkbox filters, I guess I having memory problems probably because i passing it as a Json

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/b/0b47fada01045a3dd6ee4bc2ee44ff3984627fff.png)

What would be a good way to do this filtering?

How can I load the data afer I apply the filters so no need to load so much data.

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [May 16, 2024, 8:48am UTC](https://forum.inductiveautomation.com/t/large-dataset-filtering-from-custom-data/90478/2 "2024-05-16T08:48:46Z")

</div>

400 rows is not very many. What memory problem do you see?

You could do the filtering in SQL.

---

<div class="post-metadata">

**Author:** ![Alejandro\_Alaco](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/alejandro_alaco/32/59849_2.png) [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\
**Post date:** [May 16, 2024, 8:59am UTC](https://forum.inductiveautomation.com/t/large-dataset-filtering-from-custom-data/90478/3 "2024-05-16T08:59:47Z")

</div>

How to do the filtering in SQL from the checkboxes?

This may be a good solution because there are many parameters to filter.

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [May 16, 2024, 9:08am UTC](https://forum.inductiveautomation.com/t/large-dataset-filtering-from-custom-data/90478/4 "2024-05-16T09:08:56Z")

</div>

> [@How to pass dynamic list of ids to name query params](https://forum.inductiveautomation.com/t/how-to-pass-dynamic-list-of-ids-to-name-query-params/53762):
>
> Hello, Like as code below I'd like to delete dynamic number of Ids from a table by using name query and I'd like to pass the ids list as params but I can't figure it out how to pass a list to name query. DELETE FROM dependents WHERE employee\_id IN (100 , 101, 102);