Ui-table supports ui_control

davej · 7 August 2020 17:24

aha - thanks . I assume I was doing something wrong in not being able to get that id field.
I have just tried id:cell.getRow().getIndex() - and it works if I now include id back into the input payload. !!

Do you know how to turn off the 'noise' that is being pushed out to msg.payload.
I only have a cellEdited callback as I want to be able to update single cells in a column. Not bothered about anything else. so I have no other callbacks specified.

Yet, I am finding that If I simply click on any cell in any row, I get a message pushed out to debug.
I do not have cellClick callback present. The only output that I want to get from the table is the cellEdited - and that piece is working fine.

Christian-Me · 7 August 2020 23:06

Hi Dave,

the chellClick callback is part of the "vanilla" function of ui-table. See info panel.

You can disable it by sending a empty string.

{
  "payload":null,
  "ui_control":
    {"tabulator":{"cellClick":""}}
}

or an empty function.
This is due to the mix iterative configuration based on the core functionalities.

A) core configuration done inside the editor ui
B) merge any additional config via ui_control

Hope this helps.

davej · 7 August 2020 23:51

oh jeez. Where is that documented?
I have spent some hours wading through the Tabulator doc and what there is of UI Table but never came across this.

You say look in the info panel - I am but not seeing it ???.

Christian-Me · 8 August 2020 06:05

Hi Dave,
I meant vanilla Node-RED dashboard widget ui-table not tabulator directly.

To achieve this function the cellClick callback is used.
I know the latest ui-control feature upgrade is not documented in detail. Most is described by the example flow. Sorry for that it is only lack of time that docs are not always up to date. (BTW who RTFM anyway? - I do but ...)

Christian-Me · 8 August 2020 06:31

In addition for anybody interested:

How customizing ui-table with ui_controll messages work is:

tabulator is configured by the settings in the editor UI
messages with a msg.ui_control object will add or modify features of tabulator. It do not replace the configuration done in the UI
subsequent ui_control messages are merged into the tabulator object! So they do not replace the existing config
you can modify existing column config of individual columns. The column is matched by the field property.
if you do not pass a payload with in your msg to ui-table containing ui_control the payload has to be null (this is necessary to trick the dashboard a little bit to pass ui_control objects unaltered to ui-table to perform the merge and column matching)

This is the default tabulator configuration:

{
  layout: 'fitColumns',
  autoColumns: columndata.length == 0,
  movableColumns: true,
  cellClick: 'function(e, cell) { $scope.send({topic:cell.getField(), payload:cell.getData(), row:(cell.getRow()).getPosition()}); };'
  columns: columndata,
  data: tabledata,
}

JVergara · 1 September 2020 11:50

Hello Christian,

I would like to ask, how do you do this 2 Colum Group ( Measurment & Settings) with other Columns? Because I try but I get only 1 ( the last in the column list).

here is my code of ui_control:

{
"formatterParams": {
"target": "_blank"
},
"title": "Measurements",
"columns": [
{
"title": "Value",
"field": "sensor_value",
"formatter": "plaintext",
"align": "center"
},
{
"title": "Units",
"field": "units",
"formatter": "plaintext",
"align": "center",
"width": 50
}
]
},
{
"formatterParams": {
"target": "_blank"
},
"title": "Location",
"columns": [
{
"title": "Latitude",
"field": "lat",
"formatter": "plaintext"
},
{
"title": "Longitude",
"field": "long",
"formatter": "plaintext",
"align": "center"
}
]
}

JVergara · 1 September 2020 13:04

So Is that I can get it, the three structure is not perfect decoded ??

{
   "formatterParams": {
   "target": "_blank"
     },
        "title": "Measurements",
         "columns": [
               {
                  "title": "Value",
                  "field": "sensor_value",
                  "formatter": "plaintext",
                  "align": "center"
               },
               {
                  "title": "Units",
                  "field": "units",
                  "formatter": "plaintext",
                  "align": "center",
                  "width": 50
             }
           ]
        },
        {
           "formatterParams": {
                 "target": "_blank"
            },
            "title": "Location",
            "columns": [
                  {
                      "title": "Latitude",
                       "field": "lat",
                       "formatter": "plaintext"
                  },
                  {
                       "title": "Longitude",
                       "field": "long",
                       "formatter": "plaintext",
                       "align": "center"
                  }
            ]
        }

Christian-Me · 1 September 2020 13:53

You only need for URL links to open the link on a new Tab. Can be deleted

Something is missing at the beginning too. Please refer to one of the examples of ui-table for a complete JSON object.
Perhaps paste your JSON into a JSON editor (Any node red node which imput field you can switch to json like the change node / online validators / vs code or similar) and validate it.

JVergara · 1 September 2020 14:08

here is my complete json;

{
    "tabulator": {
        "columnHeaderVertAlign": "middle",
        "columns": [
            {
                "title": "Timestamp",
                "field": "scantime",
                "formatter": "datetime",
                "formatterParams": {
                    "inputFormat": "YYYY-MM-DD HH:mm:ss)",
                    "invalidPlaceholder": "(invalid date)"
                },
                "minwidth": 150,
                "align": "center"
            },
            {
                "title": "UID / ID",
                "field": "ID",
                "formatter": "plaintext",
                "headerFilter": "id",
                "minwidth": 100,
                "align": "center"
            },
            {
                "title": "Type",
                "field": "type",
                "formatter": "plaintext",
                "align": "center"
            },
            {
                "title": "Measurements",
                "columns": [
                    {
                        "title": "Value",
                        "field": "sensor_value",
                        "formatter": "progress",
                        "formatterParams": {
                            "min": -50,
                            "max": 50,
                            "color": [
                                "blue",
                                "green",
                                "red"
                            ],
                            "legend": "function (value) {return '&nbsp;&nbsp;'+value;}",
                            "legendColor": "#101010",
                            "legendAlign": "left"
                        }
                    },
                    {
                        "title": "Units",
                        "field": "units",
                        "formatter": "plaintext",
                        "align": "center",
                        "width": 50
                    }
                ]
            },
            {
                "title": "Location",
                "columns": [
                    {
                        "title": "Latitude",
                        "field": "lat",
                        "formatter": "plaintext",
                        "width": 60
                    },
                    {
                        "title": "Longitude",
                        "field": "long",
                        "formatter": "plaintext",
                        "align": "center",
                        "width": 60
                    }
                ]
            },
            {
                "title": "NDEF content",
                "field": "content",
                "formatter": "plaintext",
                "align": "center"
            }
        ],
        "layout": "fitColumns",
        "movableRows": false,
        "groupBy": ""
    },
    "customHeight": 12
}

Christian-Me · 1 September 2020 14:13

Looks good ... and on the console?
And a screenshot would be helpfully (simply copy paste here)

JVergara · 1 September 2020 14:15

I have some Table Header:

But I would like with some like Measurement Group for location
Location
Latitude | Longitude

Christian-Me · 1 September 2020 14:26

Strange ... I see your problem now but can't find a solution without testing it on node-red.

Hope I find time this evening.

JVergara · 1 September 2020 14:35

Ok thanks. I wait you feedback

Christian-Me · 2 September 2020 07:33

My console output:

columnHeaderVertAlign perhaps a problem in the docs ... ?
minWidth! Tabulator uses camelCase (seems there ist a bug in the config-ui defined tables too.
ditto.
check how to use filters. Not with filed names!

But to your initial problem: still strange... sorry I have to dig deeper and currently no time.

JVergara · 2 September 2020 08:34

Ok Thanks so much. I try to solve with this warning.

Christian-Me · 2 September 2020 21:54

Hi.
There is a bug in the merging process of ui_control messages on column groups. Hopefully I can fix that over the weekend.
Sorry.

JVergara · 3 September 2020 05:50

Ok thanks you!!

JVergara · 4 September 2020 06:21

Hello Christian-Me ,

sorry I have some another questions about table. I would like use these 'Theme' of Tabulator ( http://tabulator.info/docs/4.7/theme) to change the format and visualization of my table. Its will be possible to do with ui_control message or another method ? because I try to do with the template_ui but I don't see any change in my table.

Thanks very much.

Christian-Me · 7 September 2020 21:06

Found and fixed the problem. Will be available soon:

To the css loading. It should be possible as others solved some issues by editing the css. But sorry, I don't know how - not the css / template guy. perhaps do a search on "ui-table css" to get any hints. There are only two css directly available "tabulator.css" and "midnight.css" depending on your ui scheme.

Chris

rce · 7 October 2020 12:08

Hi,
I'm trying to retrieve the data from a table, but i'm not sure how to do this. I would use the getData() function from tabulator + this.send command I guess, but i'm lost on how to make it work. Anyone to put me in the right direction?

Topic		Replies	Views
UI Table Adjustments Dashboard	15	3159	21 January 2022
How can I change ui-table's row of color? Dashboard	6	1171	7 August 2022
Ui-table, msg.ui_control formatters Dashboard node-red-dashboard	2	606	23 April 2023
Dashboard Detailed Table Dashboard	5	590	12 September 2020
Explore for tabulator in creating good table view Dashboard node-red-dashboard	3	210	23 September 2023

Ui-table supports ui_control

Related topics