Large dataset filtering from custom data

[Alejandro_Alaco]

Hello!

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

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

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.

[Transistor]

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

You could do the filtering in SQL.

[Alejandro_Alaco]

How to do the filtering in SQL from the checkboxes?

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

[Transistor]

How to pass dynamic list of ids to name query params

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);