# Ui-table filter issue

**URL:** <https://discourse.nodered.org/t/ui-table-filter-issue/64052>\
**Category:** Dashboard\
**Created:** [17 June 2022 08:31 UTC](https://discourse.nodered.org/t/ui-table-filter-issue/64052 "2022-06-17T08:31:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![kvramji](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/kvramji/32/59005_2.png) [@kvramji](https://discourse.nodered.org/u/kvramji)\
**Post date:** [17 June 2022 08:31 UTC](https://discourse.nodered.org/t/ui-table-filter-issue/64052/1 "2022-06-17T08:31:40Z")

</div>

I have created a dashboard which uses the ui-table node & mssql-plus nodes.  
Here is what i have when i add 20 rows to my db and table on node red

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/7/f/7fa6798483351a8b133755fac119faae5d9bae17.png)

The 3 filters work well and there are no issues.

When i increase the number of entries in my DB to say 200 and then do a filter, i notice that there is an issue with the filter as the ID column gets messed up somehow.

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/7/47110d8d9c34a20ee33aebba609f9f34e1dc2715.png)

I have 2 issues now

Issue #1 - BR3 onwards is missing at the row number 3

Issue #2 - The row numbers don't match the BR numbers as seen in the previous image of 20 DB entries.

Here are some snaps of the filter when there are 20 entries

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/c/cc480a1f8c100afb65118a0032ac00c7411eb24c.png)

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/e/e/ee61a54702f1ed109033a2be9967e11b473a7f18.png)

Here are some snaps of the filter when there are 200 entries.

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/2/b2b3e7eaad7e35be3f2dde241de8b9266c2d10e1.png)

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/7/d/7d5178605de32459226a388e7152ddc2c8e028d3.png)

I am sure a picture speaks a thousand words. Hope these images are useful to understand my issue 🙂

Any help would be appreciated.  
TIA

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [19 June 2022 12:46 UTC](https://discourse.nodered.org/t/ui-table-filter-issue/64052/2 "2022-06-19T12:46:54Z")

</div>

What is the database query you are using to get the filtered data?  
What does the db schema look like?

---

<div class="post-metadata">

**Author:** ![kvramji](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/kvramji/32/59005_2.png) [@kvramji](https://discourse.nodered.org/u/kvramji)\
**Post date:** [20 June 2022 10:31 UTC](https://discourse.nodered.org/t/ui-table-filter-issue/64052/3 "2022-06-20T10:31:52Z")

</div>

I am writing to a DB every second. But for some reason, my table on node red doesn't get refreshed.  
So i am refreshing the table everytime something is written to the db

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [20 July 2022 10:32 UTC](https://discourse.nodered.org/t/ui-table-filter-issue/64052/4 "2022-07-20T10:32:25Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.