# Ui-table filtering

**URL:** <https://discourse.nodered.org/t/ui-table-filtering/47132>\
**Category:** Dashboard\
**Created:** [14 June 2021 11:02 UTC](https://discourse.nodered.org/t/ui-table-filtering/47132 "2021-06-14T11:02:17Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![arrato](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/arrato/32/43305_2.png) [@arrato](https://discourse.nodered.org/u/arrato)\
**Post date:** [14 June 2021 11:02 UTC](https://discourse.nodered.org/t/ui-table-filtering/47132/1 "2021-06-14T11:02:18Z")

</div>

Hi all.

I have NoSQL data logger, Mariadb  
It simply stores three different fields :  
Room  
Timestamp  
Activity

I can add data, retrieve it in dashboard and display it in ui-table, but really can not understand how can I set static filter like "Room = 2"

I Crawled by examples, but can't really understand it and I stuck there. I tried to send commands from function node but can't do it.  
List does not react or displays blank table. Debug node shows command injected.

Will anyone find some time to help a newbie ?

Thank you in advance!

---

<div class="post-metadata">

**Author:** ![Christian-Me](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/christian-me/32/10774_2.png) [@Christian-Me](https://discourse.nodered.org/u/Christian-Me)\
**Post date:** [14 June 2021 12:32 UTC](https://discourse.nodered.org/t/ui-table-filtering/47132/2 "2021-06-14T12:32:38Z")

</div>

You find info on filtering here [Tabulator | JavaScript Tables & Data Grids](http://tabulator.info/docs/4.7/filter#func-builtin)

You have to send a command to ui-table to enable certain filters: [Tabulator Filter - #3 by Christian-Me](https://discourse.nodered.org/t/tabulator-filter/45646/3)

> The = filter displays only rows with data that exactly matches the filter value

So make sure that the types match so if room is a string the filter value must be string too.

if this does not work for you I think I need your flow (including demo data)

---

<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:** [14 July 2021 12:32 UTC](https://discourse.nodered.org/t/ui-table-filtering/47132/3 "2021-07-14T12:32:56Z")

</div>

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