# How can i filter data table (ui\_table) by date?

**URL:** <https://discourse.nodered.org/t/how-can-i-filter-data-table-ui-table-by-date/28122>\
**Category:** General\
**Created:** [10 June 2020 14:53 UTC](https://discourse.nodered.org/t/how-can-i-filter-data-table-ui-table-by-date/28122 "2020-06-10T14:53:52Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![DAVIDLL](https://avatars.discourse-cdn.com/v4/letter/d/4491bb/32.png) [@DAVIDLL](https://discourse.nodered.org/u/DAVIDLL)\
**Post date:** [10 June 2020 14:53 UTC](https://discourse.nodered.org/t/how-can-i-filter-data-table-ui-table-by-date/28122/1 "2020-06-10T14:53:52Z")

</div>

Hi! i'm trying to display some values from a mysql DB in a table that contains various columns (first one is the date), and i achieved to show the table in the dashboard. I added the "date" node to the table but i do not know how to filter the rows shown in the table by the date in their first column. Could someone help me? Thanks!!

---

<div class="post-metadata">

**Author:** ![DAVIDLL](https://avatars.discourse-cdn.com/v4/letter/d/4491bb/32.png) [@DAVIDLL](https://discourse.nodered.org/u/DAVIDLL)\
**Post date:** [10 June 2020 16:02 UTC](https://discourse.nodered.org/t/how-can-i-filter-data-table-ui-table-by-date/28122/3 "2020-06-10T16:02:22Z")

</div>

mm what do you mean?

---

<div class="post-metadata">

**Author:** ![ristomatti](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ristomatti/32/5857_2.png) [@ristomatti](https://discourse.nodered.org/u/ristomatti)\
**Post date:** [10 June 2020 16:08 UTC](https://discourse.nodered.org/t/how-can-i-filter-data-table-ui-table-by-date/28122/4 "2020-06-10T16:08:56Z")

</div>

I misread the question. After realising it right after posting, I deleted my reply. 🙂

---

<div class="post-metadata">

**Author:** ![DAVIDLL](https://avatars.discourse-cdn.com/v4/letter/d/4491bb/32.png) [@DAVIDLL](https://discourse.nodered.org/u/DAVIDLL)\
**Post date:** [10 June 2020 16:17 UTC](https://discourse.nodered.org/t/how-can-i-filter-data-table-ui-table-by-date/28122/5 "2020-06-10T16:17:42Z")

</div>

hahaha okay, don't worry 😊

---

<div class="post-metadata">

**Author:** ![Andrei](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/andrei/32/10446_2.png) [@Andrei](https://discourse.nodered.org/u/Andrei)\
**Post date:** [10 June 2020 16:26 UTC](https://discourse.nodered.org/t/how-can-i-filter-data-table-ui-table-by-date/28122/6 "2020-06-10T16:26:10Z")

</div>

> [@DAVIDLL](#):
>
> I added the "date" node to the table but i do not know how to filter the rows shown in the table by the date in their first column.

I sort my ui\_tables adding a change node in front of the table with below config. This will setup the properties initial Sort and persistentSort.

 ![table-01](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/d/f/df55214ab8726518d8575a29f837fc895ecc2581.png)

---

<div class="post-metadata">

**Author:** ![ristomatti](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ristomatti/32/5857_2.png) [@ristomatti](https://discourse.nodered.org/u/ristomatti)\
**Post date:** [10 June 2020 17:14 UTC](https://discourse.nodered.org/t/how-can-i-filter-data-table-ui-table-by-date/28122/7 "2020-06-10T17:14:42Z")

</div>

> [@Andrei](#):
>
> I sort my ui\_tables adding a change node in front of the table with below config. This will setup the properties initial Sort and persistentSort.

It seems like you also misread the question to be about sorting instead of filtering? 🙂

---

<div class="post-metadata">

**Author:** ![Andrei](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/andrei/32/10446_2.png) [@Andrei](https://discourse.nodered.org/u/Andrei)\
**Post date:** [10 June 2020 18:05 UTC](https://discourse.nodered.org/t/how-can-i-filter-data-table-ui-table-by-date/28122/8 "2020-06-10T18:05:43Z")

</div>

oh, filter by date... indeed I misread, 😆

For filtering i just dd this property in each column:

```
    "headerFilter": "input"
```

---

<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:** [9 August 2020 18:05 UTC](https://discourse.nodered.org/t/how-can-i-filter-data-table-ui-table-by-date/28122/9 "2020-08-09T18:05:48Z")

</div>

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