Hello, I am having troubles with filtering date in ui_table: I am showing date as DD.MM.YY HH:mm:ss. The problem is that when I filter by date, the dates with the lowest day number comes first ( 02.05.2021 will come before 05.01.2021). How can I solve this problem?

Have you tried the pagination feature of tabulator? An inject Node sending this JSON message msg.ui_control should enable pagination. { "tabulator": { "pagination":"local", "paginationSize":6 } } But you can also switch off the build in controls and place your own buttons to the dashb…

Hi, by filter you mean sorting right? If so perhaps this could help: [image] Ui-table date sort FAQs Anyone know of a neat trick to get a ui-table to do sorting by date, rather than standard numeric sort? Thanks

Thank you for your answer. I have seen this post yet I do not understand how to implement this code into my dashboard (ui_table). Do you use Template node for this?

I think if I could get an output from the node ui_table by clicking on header (sorting) of the table I could easily solve all of my problems. Is it possible to edit the code that way?

Sorry that it took a moment as I was AFK for a while :wink: as the ui-table note itself don't support datetime formatter in the config ui you have to define it by yourself by injecting a message containing a msg.ui_control parameter. you can play around with the input and output format to fit your …

Thank you @Christian-Me , Because I have a very small screen I am only showing 6 inserts at a time. I then move to next 6 with clicking on the button (right for forward and left for back). This is causing me problems because the table only sorts the 6 that I am showing. Is it possible to completely…

Yes add “headersort“:false to your column definition via a ui_control message as the config ui does not support this option. I don‘t get your complete problem showing only 6 values. You can use scrolling or pagination if you like. (Perhaps you have to set the widget size from auto to the size you …

Because of visual preference I would not like to use scrollbar (It is also kind of clumsy on my small touchscreen). I would like my table to look something like this: [image] By pressing the right arrow the table will display the next 6 inserts. Visually I like this but it messes up the sorting.

This solved my problems. Thank you @Christian-Me for your help!

Node-RED

Node-RED Forum

Ui_table filter by date

Dashboard

Christian-Me 12 May 2021 06:57 2

Hi, by filter you mean sorting right? If so perhaps this could help:

Topic		Replies	Views
Ui-table date sort FAQs	6	2607	29 February 2020
How can i filter data table (ui_table) by date? General	7	2130	9 August 2020
Simple ui_table to sort "desc" on load Dashboard	5	240	1 May 2024
Sort ui_table data by a datetime programatically at the start Dashboard	3	839	28 October 2020
Date in UI Table Dashboard	4	1404	18 January 2021

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Ui_table filter by date

Related topics