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 dashboard and control the pagination by sending the command setPage with: "first" - show the first page "prev" - show the previous page "next" - show the next page "last" - show the last page {"payload":{ "command":"setPage", "arguments":[ "next" ], "returnPromise":false } } Perhaps this solves your problem (Note: all code is not tested - I don't know how tabulator handles sorting and pagination)

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 needs. The sorter can be also configured (see original post). For further reference take a look here and here for sorting I don't think it is easy to trigger a message when the sort arrows are clicked. It could be possible by a custom sorter callback function but I think the build in functions are quite comprehensive and fast as they do sorting on the frontend data and not on the backend (what you perhaps plan to do) { "payload": null, "ui_control": { "tabulator": { "columns": [ { "title": "Time", "field": "timestamp", "width": 100, "formatter": "datetime", "formatterParams": { "inputFormat": "YYYY-MM-DD HH:mm:ss.SSS", "outputFormat": "HH:mm:ss", "invalidPlaceholder": "(invalid time)" } } ] } } } for experimenting how to use the ui_control mechanics you can use the example flow 6 ui_control interactive.

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 disable sorting for one of the columns?

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 like first) A screenshot could help to understand your issues.

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	5	2660	15 February 2020
How can i filter data table (ui_table) by date? General	6	2176	10 June 2020
Simple ui_table to sort "desc" on load Dashboard	4	274	17 April 2024
Sort ui_table data by a datetime programatically at the start Dashboard	2	853	28 September 2020
Date in UI Table Dashboard	3	1423	19 December 2020

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