@JanIwnl welcome to the forum.
At this point, you have not provided enough information for someone to help you. No one but you knows:
- what platform you are using
- what version of Node-RED or node.js you are using (you can get this from the startup log)
- are you running Docker and/or Home Assistane
what the data being sent to theui-table
node looks like - how you have configured the
ui-table
node. - what you have in the template node.
My suggestion is to add a debug
node (set to display the complete msg object) to the output of the sql
node. Then put that data into an inject
node and connect the inject
node to the ui-table
node and then select and export the inject
node, ui-table
node and template
node and paste them to a reply and answer items 1, 2 and 3 above and that will give people a chance of helping you
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
```
You can edit and correct your post by clicking the pencil icon.
See this post for more details - How to share code or flow json
.