# Filter database data using datetimepicker via namedquery and adding a button in the table component of perspective for popup but ignition dashboard getting freeze/stuck/hang

**URL:** <https://forum.inductiveautomation.com/t/filter-database-data-using-datetimepicker-via-namedquery-and-adding-a-button-in-the-table-component-of-perspective-for-popup-but-ignition-dashboard-getting-freeze-stuck-hang/114979>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [April 9, 2026, 12:58pm UTC](https://forum.inductiveautomation.com/t/filter-database-data-using-datetimepicker-via-namedquery-and-adding-a-button-in-the-table-component-of-perspective-for-popup-but-ignition-dashboard-getting-freeze-stuck-hang/114979 "2026-04-09T12:58:52Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![anand.kumar7](https://avatars.discourse-cdn.com/v4/letter/a/ad7895/32.png) [@anand.kumar7](https://forum.inductiveautomation.com/u/anand.kumar7)\
**Post date:** [April 9, 2026, 12:58pm UTC](https://forum.inductiveautomation.com/t/filter-database-data-using-datetimepicker-via-namedquery-and-adding-a-button-in-the-table-component-of-perspective-for-popup-but-ignition-dashboard-getting-freeze-stuck-hang/114979/1 "2026-04-09T12:58:52Z")

</div>

Hi All,  
I am fetching a database data for a range using two datetimepickers ( “start time” and “endtime”) via namedquery in a table component of Ignition designer , I have few columns in the database table. That is working fine.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/6/76e4183b4771baf685faca465f4e9ae5d199309c.png)

named query with two parameters

 ![2 named query](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/3/639e085fc21a446c357d1fa4c31f25510d89489e.png)

binded this named query in table component.data

 ![3 table query binding](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/a/8aaa355de9af8242f86ff3666444dea3dc398503.jpeg)

Now I have to add a new column “split” in my dashboard which will have a button for each valid row.

 ![1](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/b/6b45d5c33ccfa4bddbefb29ed6e7f69eeda134f1.png)  
This split column was not in the database table, I added it into the table component in column as follows

given pathview as “split column view” (having a split button)

 ![5 split column definition](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/a/fa4d7fd235c20b546ad8de1dd483657cae28ee0b.jpeg)

added a tranform in the table component data - query binding

 ![4 binding transform](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/2/c2c610458bdda7a3484cc8bf86b770861c406f8a.png)

but when I enable this “split” column and open client runtime database filter works on for twice and whole dashboard got freeze/stuck/hang.  
if I launch the project it again, again filter works for two times and then everything got freeze/stuck/hang even “navigations” also get freeze.  
There is no error or warning in the gateway diagnotics Logs.  
My named query is simple and quick responsive took only 0.18s to execute.

These is nothing in “split column view” only a simple button which will open a popup screen on click.

 ![6 split button popup call](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/4/d4a2bf805d18dfeb3a009fe2485e24c5210617ae.jpeg)

If someone can guide, it will be a great help guys.

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [April 9, 2026, 2:56pm UTC](https://forum.inductiveautomation.com/t/filter-database-data-using-datetimepicker-via-namedquery-and-adding-a-button-in-the-table-component-of-perspective-for-popup-but-ignition-dashboard-getting-freeze-stuck-hang/114979/2 "2026-04-09T14:56:09Z")

</div>

> [@anand.kumar7](#):
>
> but when I enable this “split” column and open client runtime database filter works on for twice

I think you need to clarify this statement. Are you clicking the split button, using the table's filtering, or something else when everything freezes up?

---

<div class="post-metadata">

**Author:** ![anand.kumar7](https://avatars.discourse-cdn.com/v4/letter/a/ad7895/32.png) [@anand.kumar7](https://forum.inductiveautomation.com/u/anand.kumar7)\
**Post date:** [April 9, 2026, 3:14pm UTC](https://forum.inductiveautomation.com/t/filter-database-data-using-datetimepicker-via-namedquery-and-adding-a-button-in-the-table-component-of-perspective-for-popup-but-ignition-dashboard-getting-freeze-stuck-hang/114979/3 "2026-04-09T15:14:04Z")

</div>

This “split“ column, I enables from table.data.colums section: with attribute(field, visible,render,viewpath).

For filter the database data in my table component I am using, Datetime pickers.  
When I launch my project, I am able to modify the datetime picker only first two times (and it wokrs too) after adding “split” column in the table component and then My whole ignition dashboard get frozen/stuck then nothing work- whether I click on any button, navigation to other screen, or any other component.

---

<div class="post-metadata">

**Author:** ![carlosbqz](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carlosbqz/32/52324_2.png) [@carlosbqz](https://forum.inductiveautomation.com/u/carlosbqz)\
**Post date:** [April 9, 2026, 3:29pm UTC](https://forum.inductiveautomation.com/t/filter-database-data-using-datetimepicker-via-namedquery-and-adding-a-button-in-the-table-component-of-perspective-for-popup-but-ignition-dashboard-getting-freeze-stuck-hang/114979/4 "2026-04-09T15:29:08Z")

</div>

I think you can skip the scripting to add the “split” column. Just add an empty column on your original query and configure it on the columns props. Hope it makes sense, that’s what I would do 🤔

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

---

<div class="post-metadata">

**Author:** ![ryan.white](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan.white/32/73193_2.png) [@ryan.white](https://forum.inductiveautomation.com/u/ryan.white)\
**Post date:** [April 9, 2026, 3:47pm UTC](https://forum.inductiveautomation.com/t/filter-database-data-using-datetimepicker-via-namedquery-and-adding-a-button-in-the-table-component-of-perspective-for-popup-but-ignition-dashboard-getting-freeze-stuck-hang/114979/5 "2026-04-09T15:47:09Z")

</div>

In addition to removing the transform script, don't have the DB cast the datetimes as strings, leave them as datetimes and let the table control display style. You can adjust how they are displayed in the column properties.

---

<div class="post-metadata">

**Author:** ![anand.kumar7](https://avatars.discourse-cdn.com/v4/letter/a/ad7895/32.png) [@anand.kumar7](https://forum.inductiveautomation.com/u/anand.kumar7)\
**Post date:** [April 9, 2026, 3:49pm UTC](https://forum.inductiveautomation.com/t/filter-database-data-using-datetimepicker-via-namedquery-and-adding-a-button-in-the-table-component-of-perspective-for-popup-but-ignition-dashboard-getting-freeze-stuck-hang/114979/6 "2026-04-09T15:49:49Z")

</div>

Are you asking to skip this table.data- Query Binding Transform Script?

 ![4 binding transform](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/2/c2c610458bdda7a3484cc8bf86b770861c406f8a.png)

My objective is to create a new column “split“- which will have a “ADD/SPLIT“ button in all the respective row data. So I took a “split button” in “split column view” and modify “split“ column.render as VIEW.

as you can see now how it appears in the split column of the table,

 ![1](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/b/6b45d5c33ccfa4bddbefb29ed6e7f69eeda134f1.png)

---

<div class="post-metadata">

**Author:** ![Sanganak\_Kasare](https://avatars.discourse-cdn.com/v4/letter/s/8c91f0/32.png) [@Sanganak\_Kasare](https://forum.inductiveautomation.com/u/Sanganak_Kasare)\
**Post date:** [April 9, 2026, 4:23pm UTC](https://forum.inductiveautomation.com/t/filter-database-data-using-datetimepicker-via-namedquery-and-adding-a-button-in-the-table-component-of-perspective-for-popup-but-ignition-dashboard-getting-freeze-stuck-hang/114979/7 "2026-04-09T16:23:02Z")

</div>

Hi,

Not sure if this is your issue but with the table component in particular we have noticed that if you have a lot rows and have the filter.results.enabled set to true. It breaks the web socket if its over the max web socket size set in the ignition.conf file.

Also, we noticed that when rendering a view in a table the performance is poor if you dont set virtualized. This setting doesn't render all the rows but only the rows visible.

---

<div class="post-metadata">

**Author:** ![anand.kumar7](https://avatars.discourse-cdn.com/v4/letter/a/ad7895/32.png) [@anand.kumar7](https://forum.inductiveautomation.com/u/anand.kumar7)\
**Post date:** [April 9, 2026, 4:26pm UTC](https://forum.inductiveautomation.com/t/filter-database-data-using-datetimepicker-via-namedquery-and-adding-a-button-in-the-table-component-of-perspective-for-popup-but-ignition-dashboard-getting-freeze-stuck-hang/114979/8 "2026-04-09T16:26:55Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/6/964f2f58ab681753650935b77bb277fdcd48bacd.png)  
removed string casting and managed from table.props.column settings. thanks for suggestion.

But I couldn’t find the alternative of removing tranform script. Please elaborate your point of view.

---

<div class="post-metadata">

**Author:** ![anand.kumar7](https://avatars.discourse-cdn.com/v4/letter/a/ad7895/32.png) [@anand.kumar7](https://forum.inductiveautomation.com/u/anand.kumar7)\
**Post date:** [April 9, 2026, 4:31pm UTC](https://forum.inductiveautomation.com/t/filter-database-data-using-datetimepicker-via-namedquery-and-adding-a-button-in-the-table-component-of-perspective-for-popup-but-ignition-dashboard-getting-freeze-stuck-hang/114979/9 "2026-04-09T16:31:05Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/3/532466e2521c5334c66eefe3fb51c7cf9dc83a5a.png)

it is already virtualized enabled in my project.

---

<div class="post-metadata">

**Author:** ![Ryan\_Deardorff](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan_deardorff/32/63815_2.png) [@Ryan\_Deardorff](https://forum.inductiveautomation.com/u/Ryan_Deardorff)\
**Post date:** [April 9, 2026, 4:43pm UTC](https://forum.inductiveautomation.com/t/filter-database-data-using-datetimepicker-via-namedquery-and-adding-a-button-in-the-table-component-of-perspective-for-popup-but-ignition-dashboard-getting-freeze-stuck-hang/114979/10 "2026-04-09T16:43:25Z")

</div>

> [@anand.kumar7](#):
>
> I couldn’t find the alternative of removing tranform script

Just add the column in the query:

```python
SELECT ignition_testing.downtime_date,
    ignition_testing.downtime_start,
    ignition_testing.downtime_end,
    ignition_testing.actual_downtime,
    ignition_testing."Part#",
    ignition_testing."Job Number",
    ignition_testing."LOC",
    "" AS split

```

---

<div class="post-metadata">

**Author:** ![anand.kumar7](https://avatars.discourse-cdn.com/v4/letter/a/ad7895/32.png) [@anand.kumar7](https://forum.inductiveautomation.com/u/anand.kumar7)\
**Post date:** [April 9, 2026, 5:14pm UTC](https://forum.inductiveautomation.com/t/filter-database-data-using-datetimepicker-via-namedquery-and-adding-a-button-in-the-table-component-of-perspective-for-popup-but-ignition-dashboard-getting-freeze-stuck-hang/114979/11 "2026-04-09T17:14:36Z")

</div>

Yes, I added the same.

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

and removed transform and used this: Got the Split column in the dashboard.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/4/c48f843eef3ab3d3f59dedb38de960be71ee793d.png)

but issue is still the same: after two filter everything frozen.😱

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [April 9, 2026, 5:22pm UTC](https://forum.inductiveautomation.com/t/filter-database-data-using-datetimepicker-via-namedquery-and-adding-a-button-in-the-table-component-of-perspective-for-popup-but-ignition-dashboard-getting-freeze-stuck-hang/114979/12 "2026-04-09T17:22:52Z")

</div>

Check your browser console when "frozen", and also look on the gateway webpage **threads** diagnostics. Take a thread dump while things are 'frozen'. If you don't know what to look for, upload it here.

---

<div class="post-metadata">

**Author:** ![anand.kumar7](https://avatars.discourse-cdn.com/v4/letter/a/ad7895/32.png) [@anand.kumar7](https://forum.inductiveautomation.com/u/anand.kumar7)\
**Post date:** [April 9, 2026, 5:59pm UTC](https://forum.inductiveautomation.com/t/filter-database-data-using-datetimepicker-via-namedquery-and-adding-a-button-in-the-table-component-of-perspective-for-popup-but-ignition-dashboard-getting-freeze-stuck-hang/114979/13 "2026-04-09T17:59:49Z")

</div>

when it is frozen this is performance and thread, I attached dumped threads too during frozen. Please guide.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/c/dcaab23ee6d585d353ec12c0cf50ea7cb6c46405.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/7/371c699028395c7940454e4d961ed281a7f478f1.jpeg)

[frozen thread\_dump.json](https://forum.inductiveautomation.com/uploads/short-url/pIuAZgzCa7hCYPH5if1dorzM1SY.json) (195.8 KB)

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [April 10, 2026, 8:40pm UTC](https://forum.inductiveautomation.com/t/filter-database-data-using-datetimepicker-via-namedquery-and-adding-a-button-in-the-table-component-of-perspective-for-popup-but-ignition-dashboard-getting-freeze-stuck-hang/114979/14 "2026-04-10T20:40:08Z")

</div>

Unfortunately there's nothing very compelling in that particular thread dump.

You should contact our [Support](https://support.inductiveautomation.com/hc/en-us) department officially, so they can remote in to your system and take a look.