Hi,
I have an issue on combining all MQTT data into a ui table at the same row.
Currently, I have 4 MQTT topics (room/1, room/2, room/3, room/4) to collect the power usage of each room. I wish to upload all data into ui table for data logger.
I found out some forum suggested to use MQTT wildcard type (ex: room/#) to publish the data into ui table, but I have no clue on creating the nodes. Can anybody willing to provide me the sample code?
Thanks.
If you want to get the data for all rooms into a message so you can feed it to the table then you can use a Join node in key/value pairs mode. See this article in the cookbook for an example of how to join messages into one object.
According to the link you provided, I am unable to do it because my inputs are dynamic, not static. If possible, can you provide me some sample code so that I can refer to that?
If you show us the flow you are using, we are more likely to be able to help. We also need the actual format of the Data Input so that we can test the flow.
In order to make code readable and usable it is necessary to surround your code with three backticks (also known as a left quote or backquote ```)
```
code goes here
```
See this post for more details - How to share code or flow json
Show us some sample data and tell us what is dynamic about it.
Here is an example for you, you will need to use your topics and make some adjustment.
[{"id":"e29c9fa46c05635b","type":"inject","z":"65617ffeb779f51c","name":"room1","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"power/room1","payload":"$round($random()*10, 2)","payloadType":"jsonata","x":130,"y":1700,"wires":[["5ac6009e36478cbc"]]},{"id":"5ac6009e36478cbc","type":"mqtt out","z":"65617ffeb779f51c","name":"send test data","topic":"","qos":"","retain":"","respTopic":"","contentType":"","userProps":"","correl":"","expiry":"","broker":"e8ba3ef5.22f4a8","x":360,"y":1720,"wires":[]},{"id":"415b655d100e82bd","type":"inject","z":"65617ffeb779f51c","name":"room4","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"power/room4","payload":"$round($random()*10, 2)","payloadType":"jsonata","x":130,"y":1820,"wires":[["5ac6009e36478cbc"]]},{"id":"fd4688d997832f64","type":"inject","z":"65617ffeb779f51c","name":"room3","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"power/room3","payload":"$round($random()*10, 2)","payloadType":"jsonata","x":130,"y":1780,"wires":[["5ac6009e36478cbc"]]},{"id":"fec7458a35197db8","type":"inject","z":"65617ffeb779f51c","name":"room2","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"power/room2","payload":"$round($random()*10, 2)","payloadType":"jsonata","x":130,"y":1740,"wires":[["5ac6009e36478cbc"]]},{"id":"13591952fa1c6b29","type":"mqtt in","z":"65617ffeb779f51c","name":"","topic":"power/+","qos":"2","datatype":"auto-detect","broker":"e8ba3ef5.22f4a8","nl":false,"rap":true,"rh":0,"inputs":0,"x":80,"y":1900,"wires":[["f2b8bed79c2453f1"]]},{"id":"f2b8bed79c2453f1","type":"change","z":"65617ffeb779f51c","name":"","rules":[{"t":"set","p":"topic","pt":"msg","to":"$split($$.topic, \"/\")[-1]","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":260,"y":1900,"wires":[["1f3b08fc723b6579"]]},{"id":"de4b294097d548de","type":"inject","z":"65617ffeb779f51c","name":"reset","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"[]","payloadType":"json","x":270,"y":1960,"wires":[["7f14b06c96251e21"]]},{"id":"1f3b08fc723b6579","type":"join","z":"65617ffeb779f51c","name":"","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":false,"timeout":"","count":"4","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":410,"y":1900,"wires":[["d3991574ce9840b5"]]},{"id":"d3991574ce9840b5","type":"change","z":"65617ffeb779f51c","name":"","rules":[{"t":"set","p":"payload.date","pt":"msg","to":"$now()","tot":"jsonata"},{"t":"move","p":"payload","pt":"msg","to":"payload.arguments[0][0]","tot":"msg"},{"t":"set","p":"payload.command","pt":"msg","to":"addRow","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":580,"y":1900,"wires":[["7f14b06c96251e21","b22b10d5bda3443c"]]},{"id":"7f14b06c96251e21","type":"ui_table","z":"65617ffeb779f51c","group":"2d4fe667.28f8ba","name":"","order":19,"width":0,"height":0,"columns":[{"field":"date","title":"Date","width":"30%","align":"left","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"room1","title":"Room1","width":"","align":"left","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"room2","title":"Room2","width":"","align":"left","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"room3","title":"Room3","width":"","align":"left","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"room4","title":"Room4","width":"","align":"left","formatter":"plaintext","formatterParams":{"target":"_blank"}}],"outputs":0,"cts":false,"x":650,"y":1940,"wires":[]},{"id":"b22b10d5bda3443c","type":"debug","z":"65617ffeb779f51c","name":"debug 236","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":630,"y":1800,"wires":[]},{"id":"e8ba3ef5.22f4a8","type":"mqtt-broker","name":"testb","broker":"192.168.1.25","port":"1883","clientid":"node-red-test","autoConnect":true,"usetls":false,"compatmode":false,"protocolVersion":"4","keepalive":"60","cleansession":true,"birthTopic":"","birthQos":"0","birthRetain":"false","birthPayload":"","birthMsg":{},"closeTopic":"","closeQos":"0","closePayload":"","closeMsg":{},"willTopic":"","willQos":"0","willPayload":"","willMsg":{},"userProps":"","sessionExpiry":""},{"id":"2d4fe667.28f8ba","type":"ui_group","name":"demo","tab":"1caa8458.b17814","order":2,"disp":true,"width":"12","collapse":false},{"id":"1caa8458.b17814","type":"ui_tab","name":"Demo","icon":"dashboard","order":1,"disabled":false,"hidden":false}]
[
{
"id": "eb90474bf03634f2",
"type": "tab",
"label": "Flow 4",
"disabled": false,
"info": "",
"env": []
},
{
"id": "13591952fa1c6b29",
"type": "mqtt in",
"z": "eb90474bf03634f2",
"name": "",
"topic": "room/Value1/#",
"qos": "2",
"datatype": "auto-detect",
"broker": "647362d8.d9d214",
"nl": false,
"rap": true,
"rh": 0,
"inputs": 0,
"x": 310,
"y": 420,
"wires": [
[
"f2b8bed79c2453f1"
]
]
},
{
"id": "f2b8bed79c2453f1",
"type": "change",
"z": "eb90474bf03634f2",
"name": "",
"rules": [
{
"t": "set",
"p": "topic",
"pt": "msg",
"to": "$split($$.topic, \"/\")[-1]",
"tot": "jsonata"
},
{
"t": "set",
"p": "payload",
"pt": "msg",
"to": "{\"payload\" : payload}",
"tot": "str"
}
],
"action": "",
"property": "",
"from": "",
"to": "",
"reg": false,
"x": 540,
"y": 420,
"wires": [
[
"1f3b08fc723b6579"
]
]
},
{
"id": "1f3b08fc723b6579",
"type": "join",
"z": "eb90474bf03634f2",
"name": "",
"mode": "custom",
"build": "object",
"property": "payload",
"propertyType": "msg",
"key": "topic",
"joiner": "\\n",
"joinerType": "str",
"accumulate": false,
"timeout": "",
"count": "2",
"reduceRight": false,
"reduceExp": "",
"reduceInit": "",
"reduceInitType": "",
"reduceFixup": "",
"x": 690,
"y": 420,
"wires": [
[
"d3991574ce9840b5"
]
]
},
{
"id": "d3991574ce9840b5",
"type": "change",
"z": "eb90474bf03634f2",
"name": "",
"rules": [
{
"t": "set",
"p": "payload.date",
"pt": "msg",
"to": "$now()",
"tot": "jsonata"
},
{
"t": "move",
"p": "payload",
"pt": "msg",
"to": "payload.arguments[0][0]",
"tot": "msg"
},
{
"t": "set",
"p": "payload.command",
"pt": "msg",
"to": "addRow",
"tot": "str"
}
],
"action": "",
"property": "",
"from": "",
"to": "",
"reg": false,
"x": 880,
"y": 420,
"wires": [
[
"b22b10d5bda3443c",
"7f14b06c96251e21"
]
]
},
{
"id": "7f14b06c96251e21",
"type": "ui_table",
"z": "eb90474bf03634f2",
"group": "6f5566a6ee302091",
"name": "",
"order": 19,
"width": 0,
"height": 0,
"columns": [
{
"field": "date",
"title": "Date",
"width": "30%",
"align": "left",
"formatter": "plaintext",
"formatterParams": {
"target": "_blank"
}
},
{
"field": "room1",
"title": "Room1",
"width": "",
"align": "left",
"formatter": "plaintext",
"formatterParams": {
"target": "_blank"
}
},
{
"field": "room2",
"title": "Room2",
"width": "",
"align": "left",
"formatter": "plaintext",
"formatterParams": {
"target": "_blank"
}
},
{
"field": "room3",
"title": "Room3",
"width": "",
"align": "left",
"formatter": "plaintext",
"formatterParams": {
"target": "_blank"
}
},
{
"field": "room4",
"title": "Room4",
"width": "",
"align": "left",
"formatter": "plaintext",
"formatterParams": {
"target": "_blank"
}
}
],
"outputs": 0,
"cts": false,
"x": 1070,
"y": 440,
"wires": []
},
{
"id": "b22b10d5bda3443c",
"type": "debug",
"z": "eb90474bf03634f2",
"name": "debug",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "payload",
"targetType": "msg",
"statusVal": "",
"statusType": "auto",
"x": 1070,
"y": 360,
"wires": []
},
{
"id": "68ea734e80329471",
"type": "inject",
"z": "eb90474bf03634f2",
"name": "",
"props": [
{
"p": "payload"
},
{
"p": "topic",
"vt": "str"
}
],
"repeat": "8",
"crontab": "",
"once": true,
"onceDelay": 0.1,
"topic": "",
"payload": "",
"payloadType": "date",
"x": 310,
"y": 200,
"wires": [
[
"d2eecff14d47bd5b"
]
]
},
{
"id": "d2eecff14d47bd5b",
"type": "mqtt out",
"z": "eb90474bf03634f2",
"name": "",
"topic": "room/Value1/1",
"qos": "",
"retain": "",
"respTopic": "",
"contentType": "",
"userProps": "",
"correl": "",
"expiry": "",
"broker": "647362d8.d9d214",
"x": 500,
"y": 200,
"wires": []
},
{
"id": "b6f0791bbd96f496",
"type": "mqtt out",
"z": "eb90474bf03634f2",
"name": "",
"topic": "room/Value1/2",
"qos": "",
"retain": "",
"respTopic": "",
"contentType": "",
"userProps": "",
"correl": "",
"expiry": "",
"broker": "647362d8.d9d214",
"x": 500,
"y": 280,
"wires": []
},
{
"id": "cc520ce65fbe2b6a",
"type": "inject",
"z": "eb90474bf03634f2",
"name": "",
"props": [
{
"p": "payload"
},
{
"p": "topic",
"vt": "str"
}
],
"repeat": "8",
"crontab": "",
"once": true,
"onceDelay": "0.5",
"topic": "",
"payload": "",
"payloadType": "date",
"x": 310,
"y": 280,
"wires": [
[
"b6f0791bbd96f496"
]
]
},
{
"id": "647362d8.d9d214",
"type": "mqtt-broker",
"name": "",
"broker": "localhost",
"port": "1883",
"clientid": "",
"usetls": false,
"compatmode": false,
"keepalive": "60",
"cleansession": true,
"birthTopic": "",
"birthQos": "0",
"birthPayload": "",
"closeTopic": "",
"closeQos": "0",
"closePayload": "",
"willTopic": "",
"willQos": "0",
"willPayload": ""
},
{
"id": "6f5566a6ee302091",
"type": "ui_group",
"name": "Group 1",
"tab": "d6eb2d1eb564a3bc",
"order": 1,
"disp": true,
"width": 6
},
{
"id": "d6eb2d1eb564a3bc",
"type": "ui_tab",
"name": "Flow4",
"icon": "dashboard",
"order": 18,
"disabled": false,
"hidden": false
}
]
I tried to use timestamp to generate new data every 8 seconds and the data I want to show inside the ui table is timestamp, so as to show my input data is dynamic data.
Then, I want to input the data to ui table by using MQTT wildcard type.
The output I want is the data is like a data logger, whenever the system is running, the value from each MQTT topic will be write into the ui table, as shown in the link: How to make a dynamic Table for MQTT in data - #3 by DemalCal96
[
{
"id": "eb90474bf03634f2",
"type": "tab",
"label": "Flow 4",
"disabled": false,
"info": "",
"env": []
},
{
"id": "391ff15c311b00d2",
"type": "mqtt in",
"z": "eb90474bf03634f2",
"name": "",
"topic": "room/Value/1",
"qos": "2",
"datatype": "auto-detect",
"broker": "fad0edd9443a7d21",
"nl": false,
"rap": true,
"rh": 0,
"inputs": 0,
"x": 250,
"y": 560,
"wires": [
[
"6de91f63aebfaaa3",
"91123d7b12452fe3"
]
]
},
{
"id": "6de91f63aebfaaa3",
"type": "function",
"z": "eb90474bf03634f2",
"name": "function 18",
"func": "msg.temp = msg.payload;\nreturn msg;",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 430,
"y": 560,
"wires": [
[
"6dea5e38bd5f9cdf"
]
]
},
{
"id": "6fde2bdece836903",
"type": "function",
"z": "eb90474bf03634f2",
"name": "function 19",
"func": "msg.payload = [\n {\n \"timestamp\": new Date(msg.timestamp).toLocaleString(),\n \"temperature\": msg.temp,\n \"humidity\": msg.humi,\n\n\n }\n];\nreturn msg;",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 770,
"y": 600,
"wires": [
[
"e3795e248eb51de9"
]
]
},
{
"id": "6c5b5b120265a6eb",
"type": "mqtt in",
"z": "eb90474bf03634f2",
"name": "",
"topic": "room/Value/2",
"qos": "2",
"datatype": "auto-detect",
"broker": "fad0edd9443a7d21",
"nl": false,
"rap": true,
"rh": 0,
"inputs": 0,
"x": 250,
"y": 640,
"wires": [
[
"8383fb95606f8823",
"a67e69eec9903f1b"
]
]
},
{
"id": "8383fb95606f8823",
"type": "function",
"z": "eb90474bf03634f2",
"name": "function 20",
"func": "msg.humi = msg.payload;\nreturn msg;",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 430,
"y": 640,
"wires": [
[
"6dea5e38bd5f9cdf"
]
]
},
{
"id": "e3795e248eb51de9",
"type": "ui_table",
"z": "eb90474bf03634f2",
"group": "6f5566a6ee302091",
"name": "",
"order": 19,
"width": 0,
"height": 0,
"columns": [
{
"field": "timestamp",
"title": "Date",
"width": "30%",
"align": "left",
"formatter": "plaintext",
"formatterParams": {
"target": "_blank"
}
},
{
"field": "temperature",
"title": "Room1",
"width": "",
"align": "left",
"formatter": "plaintext",
"formatterParams": {
"target": "_blank"
}
},
{
"field": "humidity",
"title": "Room2",
"width": "",
"align": "left",
"formatter": "plaintext",
"formatterParams": {
"target": "_blank"
}
},
{
"field": "room3",
"title": "Room3",
"width": "",
"align": "left",
"formatter": "plaintext",
"formatterParams": {
"target": "_blank"
}
},
{
"field": "room4",
"title": "Room4",
"width": "",
"align": "left",
"formatter": "plaintext",
"formatterParams": {
"target": "_blank"
}
}
],
"outputs": 0,
"cts": false,
"x": 930,
"y": 600,
"wires": []
},
{
"id": "91123d7b12452fe3",
"type": "debug",
"z": "eb90474bf03634f2",
"name": "debug",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "payload",
"targetType": "msg",
"statusVal": "",
"statusType": "auto",
"x": 410,
"y": 500,
"wires": []
},
{
"id": "a67e69eec9903f1b",
"type": "debug",
"z": "eb90474bf03634f2",
"name": "debug",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "payload",
"targetType": "msg",
"statusVal": "",
"statusType": "auto",
"x": 410,
"y": 700,
"wires": []
},
{
"id": "6dea5e38bd5f9cdf",
"type": "join",
"z": "eb90474bf03634f2",
"name": "",
"mode": "custom",
"build": "object",
"property": "payload",
"propertyType": "msg",
"key": "topic",
"joiner": "\\n",
"joinerType": "str",
"accumulate": false,
"timeout": "",
"count": "2",
"reduceRight": false,
"reduceExp": "",
"reduceInit": "",
"reduceInitType": "",
"reduceFixup": "",
"x": 610,
"y": 600,
"wires": [
[
"6fde2bdece836903"
]
]
},
{
"id": "60e222c4d757a279",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 2,
"width": 24,
"height": 1
},
{
"id": "6c89683b55b89676",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 3,
"width": 24,
"height": 1
},
{
"id": "9030838e1ebf9689",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 7,
"width": 4,
"height": 1
},
{
"id": "0dfe63c881942f8f",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 9,
"width": 2,
"height": 1
},
{
"id": "d4989945c2af4f50",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 10,
"width": 4,
"height": 1
},
{
"id": "2b2386f4e8c633b2",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 11,
"width": 2,
"height": 1
},
{
"id": "74753ad4d37c922e",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 12,
"width": 4,
"height": 1
},
{
"id": "231dbbfff281e746",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 13,
"width": 2,
"height": 1
},
{
"id": "8ea5fa8b5094f2f9",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 14,
"width": 4,
"height": 1
},
{
"id": "c5f41f7f189e5b42",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 16,
"width": 2,
"height": 1
},
{
"id": "d5a85771e08f9bfc",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 18,
"width": 16,
"height": 1
},
{
"id": "4e15f060b9d2a8e7",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 19,
"width": 2,
"height": 1
},
{
"id": "1026abd9a1ed67db",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 20,
"width": 16,
"height": 1
},
{
"id": "f9f462bf9a0f0eeb",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 21,
"width": 2,
"height": 1
},
{
"id": "374f91fc665fa0d4",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 22,
"width": 16,
"height": 1
},
{
"id": "dbea46012e487e49",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 23,
"width": 2,
"height": 1
},
{
"id": "5c2a58d7d827062d",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 24,
"width": 24,
"height": 1
},
{
"id": "da0653eb586fccca",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 25,
"width": 22,
"height": 1
},
{
"id": "f3ef2be7e982037a",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 27,
"width": 2,
"height": 1
},
{
"id": "b23c901aaf9f33d8",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 30,
"width": 10,
"height": 1
},
{
"id": "63642963ec1463b5",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 31,
"width": 2,
"height": 1
},
{
"id": "1c1ef419726482bc",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 32,
"width": 10,
"height": 1
},
{
"id": "5a1347c3d5c51c2f",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 33,
"width": 2,
"height": 1
},
{
"id": "48b534a52ad735cb",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 34,
"width": 10,
"height": 1
},
{
"id": "71d0470bcfe757d9",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 35,
"width": 2,
"height": 1
},
{
"id": "a1793790a7159696",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 36,
"width": 12,
"height": 1
},
{
"id": "1dc04a783af09de6",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 38,
"width": 24,
"height": 1
},
{
"id": "873e27f8eaaea457",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 39,
"width": 24,
"height": 1
},
{
"id": "1e523d4aaa2addaf",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 40,
"width": 24,
"height": 1
},
{
"id": "9cce3a213f266c27",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 41,
"width": 24,
"height": 1
},
{
"id": "8f860374b003d18e",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 43,
"width": 24,
"height": 1
},
{
"id": "bfa7be5760d9b9e5",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 44,
"width": 24,
"height": 1
},
{
"id": "2d129f83c2d58eec",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 45,
"width": 24,
"height": 1
},
{
"id": "fad0edd9443a7d21",
"type": "mqtt-broker",
"name": "",
"broker": "91.121.93.94",
"port": "1883",
"clientid": "test-client",
"autoConnect": true,
"usetls": false,
"protocolVersion": "4",
"keepalive": "60",
"cleansession": true,
"birthTopic": "",
"birthQos": "0",
"birthPayload": "",
"birthMsg": {},
"closeTopic": "",
"closeQos": "0",
"closePayload": "",
"closeMsg": {},
"willTopic": "",
"willQos": "0",
"willPayload": "",
"willMsg": {},
"userProps": "",
"sessionExpiry": ""
},
{
"id": "6f5566a6ee302091",
"type": "ui_group",
"name": "Group 1",
"tab": "d6eb2d1eb564a3bc",
"order": 1,
"disp": true,
"width": 6
},
{
"id": "d5da3e9b.46abf",
"type": "ui_group",
"name": "Sensor Node",
"tab": "",
"order": 2,
"disp": true,
"width": "30",
"collapse": false,
"className": ""
},
{
"id": "d6eb2d1eb564a3bc",
"type": "ui_tab",
"name": "Flow4",
"icon": "dashboard",
"order": 18,
"disabled": false,
"hidden": false
}
]
I succeeded in making two data sets visible in a table (as code uploaded), but how can I make the input data sets visible in the next row so that all input data are shown in a single table?
I managed to show all data in a row, but how to make the data always add to the new row? It is because I want to display the old and new data on the same ui table
Exactly as my example above does.
[
{
"id": "eb90474bf03634f2",
"type": "tab",
"label": "Flow 4",
"disabled": false,
"info": "",
"env": []
},
{
"id": "6de91f63aebfaaa3",
"type": "function",
"z": "eb90474bf03634f2",
"name": "Convert to global",
"func": "global.set(\"tabletempG\", msg.payload);\n\nreturn msg;",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 450,
"y": 560,
"wires": [
[
"6dea5e38bd5f9cdf"
]
]
},
{
"id": "6fde2bdece836903",
"type": "function",
"z": "eb90474bf03634f2",
"name": "function 19",
"func": "var obtaindata0 = global.get(\"timestampG\");\nvar obtaindata1 = global.get(\"tabletempG\");\nvar obtaindata2 = global.get(\"tablehumiG\");\nvar obtaindata3 = global.get(\"tablewaterG\");\nvar obtaindata4 = global.get(\"tablerainfallG\");\nvar obtaindata5 = global.get(\"tableLEDG\");\n\n\nmsg.payload = [ \n {\n \"timestamp\": obtaindata0,\n \"temperature\": obtaindata1,\n \"humidity\": obtaindata2,\n \"waterlevel\": obtaindata3,\n \"rainfall\": obtaindata4,\n \"LED\": obtaindata5,\n }\n];\n\nreturn msg;",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 950,
"y": 840,
"wires": [
[
"db5af3dcfeacd63c",
"2068320627081e1e"
]
]
},
{
"id": "8383fb95606f8823",
"type": "function",
"z": "eb90474bf03634f2",
"name": "Convert to global",
"func": "global.set(\"tablehumiG\", msg.payload);\nreturn msg;",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 450,
"y": 640,
"wires": [
[
"6dea5e38bd5f9cdf"
]
]
},
{
"id": "e3795e248eb51de9",
"type": "ui_table",
"z": "eb90474bf03634f2",
"group": "6f5566a6ee302091",
"name": "",
"order": 1,
"width": 18,
"height": 1,
"columns": [
{
"field": "timestamp",
"title": "Date & Time",
"width": "22%",
"align": "center",
"formatter": "plaintext",
"formatterParams": {
"target": "_blank"
}
},
{
"field": "temperature",
"title": "Temperature (°C)",
"width": "17%",
"align": "center",
"formatter": "plaintext",
"formatterParams": {
"target": "_blank"
}
},
{
"field": "humidity",
"title": "Relative Humidity (%)",
"width": "20%",
"align": "center",
"formatter": "plaintext",
"formatterParams": {
"target": "_blank"
}
},
{
"field": "waterlevel",
"title": "Water Level (m)",
"width": "17%",
"align": "center",
"formatter": "plaintext",
"formatterParams": {
"target": "_blank"
}
},
{
"field": "rainfall",
"title": "Rainfall (mm)",
"width": "14%",
"align": "center",
"formatter": "plaintext",
"formatterParams": {
"target": "_blank"
}
},
{
"field": "LED",
"title": "Motor",
"width": "10%",
"align": "center",
"formatter": "tickCross",
"formatterParams": {
"target": "_blank"
}
}
],
"outputs": 0,
"cts": false,
"x": 1410,
"y": 840,
"wires": []
},
{
"id": "6dea5e38bd5f9cdf",
"type": "join",
"z": "eb90474bf03634f2",
"name": "",
"mode": "custom",
"build": "object",
"property": "payload",
"propertyType": "msg",
"key": "topic",
"joiner": "\\n",
"joinerType": "str",
"accumulate": false,
"timeout": "",
"count": "4",
"reduceRight": false,
"reduceExp": "",
"reduceInit": "",
"reduceInitType": "",
"reduceFixup": "",
"x": 730,
"y": 700,
"wires": [
[
"6fde2bdece836903"
]
]
},
{
"id": "b691d6c31a21d5da",
"type": "mqtt in",
"z": "eb90474bf03634f2",
"name": "",
"topic": "room/temperature",
"qos": "2",
"datatype": "auto-detect",
"broker": "fad0edd9443a7d21",
"nl": false,
"rap": true,
"rh": 0,
"inputs": 0,
"x": 230,
"y": 560,
"wires": [
[
"6de91f63aebfaaa3"
]
]
},
{
"id": "ad09411a554d6314",
"type": "mqtt in",
"z": "eb90474bf03634f2",
"name": "",
"topic": "room/RH",
"qos": "2",
"datatype": "auto-detect",
"broker": "fad0edd9443a7d21",
"nl": false,
"rap": true,
"rh": 0,
"inputs": 0,
"x": 260,
"y": 640,
"wires": [
[
"8383fb95606f8823"
]
]
},
{
"id": "280340dca8fd3f70",
"type": "mqtt in",
"z": "eb90474bf03634f2",
"name": "",
"topic": "room/rainfall",
"qos": "2",
"datatype": "auto-detect",
"broker": "fad0edd9443a7d21",
"nl": false,
"rap": true,
"rh": 0,
"inputs": 0,
"x": 250,
"y": 800,
"wires": [
[
"3d0ac081d960d2ca",
"2bb5565794518d2a"
]
]
},
{
"id": "98dc55f8397d8abc",
"type": "mqtt in",
"z": "eb90474bf03634f2",
"name": "",
"topic": "room/waterLevel",
"qos": "2",
"datatype": "auto-detect",
"broker": "fad0edd9443a7d21",
"nl": false,
"rap": true,
"rh": 0,
"inputs": 0,
"x": 240,
"y": 720,
"wires": [
[
"1215a45fb0e5b173"
]
]
},
{
"id": "434fd8dea6e37959",
"type": "mqtt in",
"z": "eb90474bf03634f2",
"name": "LED Status",
"topic": "room/ledstatus",
"qos": "2",
"datatype": "auto-detect",
"broker": "fad0edd9443a7d21",
"nl": false,
"rap": true,
"rh": 0,
"inputs": 0,
"x": 250,
"y": 920,
"wires": [
[
"fe079a0ed62fac27"
]
]
},
{
"id": "3d0ac081d960d2ca",
"type": "function",
"z": "eb90474bf03634f2",
"name": "Convert to global",
"func": "global.set(\"tablerainfallG\", msg.payload);\nreturn msg;",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 450,
"y": 800,
"wires": [
[
"6dea5e38bd5f9cdf"
]
]
},
{
"id": "1215a45fb0e5b173",
"type": "function",
"z": "eb90474bf03634f2",
"name": "Convert to global",
"func": "global.set(\"tablewaterG\", msg.payload);\n\nreturn msg;",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 450,
"y": 720,
"wires": [
[
"6dea5e38bd5f9cdf"
]
]
},
{
"id": "f8bc32727f124d18",
"type": "function",
"z": "eb90474bf03634f2",
"name": "Convert to global",
"func": "global.set(\"tableLEDG\", msg.payload);\n\nreturn msg;",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 650,
"y": 920,
"wires": [
[
"6fde2bdece836903",
"d9eb80bdd775fdf7"
]
]
},
{
"id": "db5af3dcfeacd63c",
"type": "debug",
"z": "eb90474bf03634f2",
"name": "debug",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "payload",
"targetType": "msg",
"statusVal": "",
"statusType": "auto",
"x": 1250,
"y": 660,
"wires": []
},
{
"id": "4e746eb2a211b137",
"type": "function",
"z": "eb90474bf03634f2",
"name": "function 22",
"func": "var timestamp = msg.payload;\nvar time = new Date(timestamp).toLocaleString();\nglobal.set(\"timestampG\", time);\nreturn msg;",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 690,
"y": 820,
"wires": [
[
"6fde2bdece836903"
]
]
},
{
"id": "2bb5565794518d2a",
"type": "change",
"z": "eb90474bf03634f2",
"name": "",
"rules": [
{
"t": "set",
"p": "payload",
"pt": "msg",
"to": "",
"tot": "date"
}
],
"action": "",
"property": "",
"from": "",
"to": "",
"reg": false,
"x": 460,
"y": 860,
"wires": [
[
"4e746eb2a211b137"
]
]
},
{
"id": "2068320627081e1e",
"type": "change",
"z": "eb90474bf03634f2",
"name": "",
"rules": [
{
"t": "set",
"p": "payload.command",
"pt": "msg",
"to": "addRow",
"tot": "str"
}
],
"action": "",
"property": "",
"from": "",
"to": "",
"reg": false,
"x": 1200,
"y": 840,
"wires": [
[
"e3795e248eb51de9"
]
]
},
{
"id": "fe079a0ed62fac27",
"type": "change",
"z": "eb90474bf03634f2",
"name": "",
"rules": [
{
"t": "set",
"p": "payload",
"pt": "msg",
"to": "true",
"tot": "bool"
}
],
"action": "",
"property": "",
"from": "",
"to": "",
"reg": false,
"x": 480,
"y": 980,
"wires": [
[
"f8bc32727f124d18",
"0df4b8c167ebe8d2"
]
]
},
{
"id": "0df4b8c167ebe8d2",
"type": "debug",
"z": "eb90474bf03634f2",
"name": "debug",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "payload",
"targetType": "msg",
"statusVal": "",
"statusType": "auto",
"x": 650,
"y": 1020,
"wires": []
},
{
"id": "d9eb80bdd775fdf7",
"type": "debug",
"z": "eb90474bf03634f2",
"name": "debug",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "payload",
"targetType": "msg",
"statusVal": "",
"statusType": "auto",
"x": 830,
"y": 960,
"wires": []
},
{
"id": "60e222c4d757a279",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 2,
"width": 24,
"height": 1
},
{
"id": "6c89683b55b89676",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 3,
"width": 24,
"height": 1
},
{
"id": "9030838e1ebf9689",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 7,
"width": 4,
"height": 1
},
{
"id": "0dfe63c881942f8f",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 9,
"width": 2,
"height": 1
},
{
"id": "d4989945c2af4f50",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 10,
"width": 4,
"height": 1
},
{
"id": "2b2386f4e8c633b2",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 11,
"width": 2,
"height": 1
},
{
"id": "74753ad4d37c922e",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 12,
"width": 4,
"height": 1
},
{
"id": "231dbbfff281e746",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 13,
"width": 2,
"height": 1
},
{
"id": "8ea5fa8b5094f2f9",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 14,
"width": 4,
"height": 1
},
{
"id": "c5f41f7f189e5b42",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 16,
"width": 2,
"height": 1
},
{
"id": "d5a85771e08f9bfc",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 18,
"width": 16,
"height": 1
},
{
"id": "4e15f060b9d2a8e7",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 19,
"width": 2,
"height": 1
},
{
"id": "1026abd9a1ed67db",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 20,
"width": 16,
"height": 1
},
{
"id": "f9f462bf9a0f0eeb",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 21,
"width": 2,
"height": 1
},
{
"id": "374f91fc665fa0d4",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 22,
"width": 16,
"height": 1
},
{
"id": "dbea46012e487e49",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 23,
"width": 2,
"height": 1
},
{
"id": "5c2a58d7d827062d",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 24,
"width": 24,
"height": 1
},
{
"id": "da0653eb586fccca",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 25,
"width": 22,
"height": 1
},
{
"id": "f3ef2be7e982037a",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 27,
"width": 2,
"height": 1
},
{
"id": "b23c901aaf9f33d8",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 30,
"width": 10,
"height": 1
},
{
"id": "63642963ec1463b5",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 31,
"width": 2,
"height": 1
},
{
"id": "1c1ef419726482bc",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 32,
"width": 10,
"height": 1
},
{
"id": "5a1347c3d5c51c2f",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 33,
"width": 2,
"height": 1
},
{
"id": "48b534a52ad735cb",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 34,
"width": 10,
"height": 1
},
{
"id": "71d0470bcfe757d9",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 35,
"width": 2,
"height": 1
},
{
"id": "a1793790a7159696",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 36,
"width": 12,
"height": 1
},
{
"id": "1dc04a783af09de6",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 38,
"width": 24,
"height": 1
},
{
"id": "873e27f8eaaea457",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 39,
"width": 24,
"height": 1
},
{
"id": "1e523d4aaa2addaf",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 40,
"width": 24,
"height": 1
},
{
"id": "9cce3a213f266c27",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 41,
"width": 24,
"height": 1
},
{
"id": "8f860374b003d18e",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 43,
"width": 24,
"height": 1
},
{
"id": "bfa7be5760d9b9e5",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 44,
"width": 24,
"height": 1
},
{
"id": "2d129f83c2d58eec",
"type": "ui_spacer",
"z": "eb90474bf03634f2",
"name": "spacer",
"group": "d5da3e9b.46abf",
"order": 45,
"width": 24,
"height": 1
},
{
"id": "6f5566a6ee302091",
"type": "ui_group",
"name": "Group 1",
"tab": "d6eb2d1eb564a3bc",
"order": 1,
"disp": true,
"width": 18
},
{
"id": "fad0edd9443a7d21",
"type": "mqtt-broker",
"name": "",
"broker": "91.121.93.94",
"port": "1883",
"clientid": "test-client",
"autoConnect": true,
"usetls": false,
"protocolVersion": "4",
"keepalive": "60",
"cleansession": true,
"birthTopic": "",
"birthQos": "0",
"birthPayload": "",
"birthMsg": {},
"closeTopic": "",
"closeQos": "0",
"closePayload": "",
"closeMsg": {},
"willTopic": "",
"willQos": "0",
"willPayload": "",
"willMsg": {},
"userProps": "",
"sessionExpiry": ""
},
{
"id": "d5da3e9b.46abf",
"type": "ui_group",
"name": "Sensor Node",
"tab": "",
"order": 2,
"disp": true,
"width": "30",
"collapse": false,
"className": ""
},
{
"id": "d6eb2d1eb564a3bc",
"type": "ui_tab",
"name": "Flow4",
"icon": "dashboard",
"order": 18,
"disabled": false,
"hidden": false
}
]
This is the flow I did. I tried to combine the example you gave to me, but it is unsuccessful. Can you guide me on it?
Thanks
Your flow has 35 ui-nodes that if i load i would have to delete manually.
Here is another way to add the data to the table by storing the data table in flow context, so you can append new data to it. I have limited it to 200 entries, editable in the change node JSONata expression. In this example I append data to top of table.
[{"id":"2bb5565794518d2a","type":"change","z":"eb90474bf03634f2","name":"","rules":[{"t":"set","p":"topic","pt":"msg","to":"$split($$.topic, \"/\")[-1]","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":250.00000762939453,"y":836.2500371932983,"wires":[["6dea5e38bd5f9cdf"]]},{"id":"280340dca8fd3f70","type":"mqtt in","z":"eb90474bf03634f2","name":"","topic":"room/+","qos":"2","datatype":"auto-detect","broker":"e8ba3ef5.22f4a8","nl":false,"rap":true,"rh":0,"inputs":0,"x":100.00000762939453,"y":836.2500371932983,"wires":[["2bb5565794518d2a"]]},{"id":"6dea5e38bd5f9cdf","type":"join","z":"eb90474bf03634f2","name":"join","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":false,"timeout":"","count":"5","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":400.00000762939453,"y":836.2500371932983,"wires":[["5905fbdbfb3a4952"]]},{"id":"5905fbdbfb3a4952","type":"change","z":"eb90474bf03634f2","name":"","rules":[{"t":"set","p":"payload.timestamp","pt":"msg","to":"$moment().tz(\"Europe/London\").format(\"YYYY/MM/DD HH:mm:ss\")","tot":"jsonata"},{"t":"set","p":"table_data","pt":"flow","to":"$append([$$.payload],$flowContext(\"table_data\")[])[[0..200]]","tot":"jsonata"},{"t":"set","p":"payload","pt":"msg","to":"table_data","tot":"flow"}],"action":"","property":"","from":"","to":"","reg":false,"x":600,"y":840,"wires":[["e3795e248eb51de9","db5af3dcfeacd63c"]]},{"id":"e3795e248eb51de9","type":"ui_table","z":"eb90474bf03634f2","group":"6f5566a6ee302091","name":"","order":1,"width":18,"height":1,"columns":[{"field":"timestamp","title":"Date & Time","width":"22%","align":"center","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"temperature","title":"Temperature (°C)","width":"17%","align":"center","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"RH","title":"Relative Humidity (%)","width":"20%","align":"center","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"waterLevel","title":"Water Level (m)","width":"17%","align":"center","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"rainfall","title":"Rainfall (mm)","width":"14%","align":"center","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"ledstatus","title":"Motor","width":"10%","align":"center","formatter":"tickCross","formatterParams":{"target":"_blank"}}],"outputs":0,"cts":false,"x":830,"y":840,"wires":[]},{"id":"db5af3dcfeacd63c","type":"debug","z":"eb90474bf03634f2","name":"debug","active":true,"tosidebar":true,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","statusVal":"payload.arguments[0][0].ledstatus","statusType":"msg","x":620.0000076293945,"y":716.2500371932983,"wires":[]},{"id":"d95b84f983b78c88","type":"inject","z":"eb90474bf03634f2","name":"led status","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"room/ledstatus","payload":"$round($random())","payloadType":"jsonata","x":240,"y":660,"wires":[["ee4307e0690cc39e"]]},{"id":"d170c19bc6af3f3c","type":"inject","z":"eb90474bf03634f2","name":"rainfall","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"room/rainfall","payload":"$round($random()*10, 2)","payloadType":"jsonata","x":230,"y":620,"wires":[["ee4307e0690cc39e"]]},{"id":"a878762a751c1f0b","type":"inject","z":"eb90474bf03634f2","name":"waterlevel","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"room/waterLevel","payload":"$round($random()*10, 2)","payloadType":"jsonata","x":240,"y":580,"wires":[["ee4307e0690cc39e"]]},{"id":"fed906875fb9dc94","type":"inject","z":"eb90474bf03634f2","name":"rh","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"room/RH","payload":"$round($random()*10, 2)","payloadType":"jsonata","x":230,"y":540,"wires":[["ee4307e0690cc39e"]]},{"id":"c8d93b4324f72787","type":"inject","z":"eb90474bf03634f2","name":"temp","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"room/temperature","payload":"$round($random()*10, 2)","payloadType":"jsonata","x":230,"y":500,"wires":[["ee4307e0690cc39e"]]},{"id":"ee4307e0690cc39e","type":"mqtt out","z":"eb90474bf03634f2","name":"send test data","topic":"","qos":"","retain":"","respTopic":"","contentType":"","userProps":"","correl":"","expiry":"","broker":"e8ba3ef5.22f4a8","x":460,"y":520,"wires":[]},{"id":"e8ba3ef5.22f4a8","type":"mqtt-broker","name":"testb","broker":"192.168.1.25","port":"1883","clientid":"node-red-test","autoConnect":true,"usetls":false,"compatmode":false,"protocolVersion":"4","keepalive":"60","cleansession":true,"birthTopic":"","birthQos":"0","birthRetain":"false","birthPayload":"","birthMsg":{},"closeTopic":"","closeQos":"0","closePayload":"","closeMsg":{},"willTopic":"","willQos":"0","willPayload":"","willMsg":{},"userProps":"","sessionExpiry":""},{"id":"6f5566a6ee302091","type":"ui_group","name":"Group 1","tab":"d6eb2d1eb564a3bc","order":1,"disp":true,"width":18},{"id":"d6eb2d1eb564a3bc","type":"ui_tab","name":"Flow4","icon":"dashboard","order":18,"disabled":false,"hidden":false}]
I really don't understand why you are storing data to globals when available in flow message.
Thanks for your help.
Actually, my first attempt is using the wildcard type, but no data are shown in the table. Then, I tried to separate all the data and join them together, and it works.
I stored the data in global as for future expansion, so that I would not need to duplicate the same node on the same tab.
Thanks for your code, it works. However, I have an issue on displaying the data. Since the 5 input data will be sent at the same time, why the table not showing all data? Some data are shown but some are not. May I know what is the possible issue that causes this situation happens?
From the picture, I realised some consequent rows have a short time interval. The data I sent through mqtt is 8 seconds tie interval.
Let me get my crystal ball. Or you could supply the data i need to answer that question
At a guess my uitable is configured different to yours, check the property names. Or the data was not received when the join finished.
As to globals the whole table is stored so no need for global of individual values, and context can also lead to race conditions, if not craeful
May I know is there any way to solve this issue?
I think you can try to connect to my broker to get the supply data
Its not the lack of data, you show me an image, tell me there is an issue, but i have no way of knowing how you have configured things. I have given two very good examples but you seem to have ignored their layout, as my testing with my examples leaves no gaps.
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.
The OpenJS Foundation | Terms of Use | Privacy Policy | OpenJS Foundation Bylaws | Trademark Policy | Trademark List | Cookie Policy
