Hello All right with you. I'm trying to display values from a database in Firebird and showing them to a table of type UI-Template NODE - I can read normally in the database by SELECT Query but I can not see. I try several examples without success. Could someone please give me a help of what I'm d…

It is not possible to import your code for analysis. Please edit the original post to correct the formatting, taking in consideration the guideline from here: [image] How to share code or flow json FAQs To share code samples or flow json in this forum, you need to take ca…

Thank you very much for the contact [{"id":"c7e84e4f.2fcce","type":"tab","label":"Flow 2","disabled":false,"info":""},{"id":"c80ee3b6.e3a8e","type":"function","z":"c7e84e4f.2fcce","name":"SQL - Select","func":"var select = {topic: \"SELECT * FROM NDBD\"};\nreturn select;\n","outputs":1,"noerr":0,"x…

Dear. Does anyone have any tips please? Thanks

Looking at the picture you attached to the OP I wonder if you tried to convert your data to string type before sending it to the UI template node. I don´t know if the UI template node is able to handle buffer data types.

@Battassini - I see that you've marked this post as 'Urgent'. Why is your post more urgent than everyone else's posts??

Dear. I believe everyone is important - but I can take it without problems. Thanks

Andrei I tried to convert to string but I do not know if I did it correctly. I tried to use the function: msg.payload = msg.payload.toString(); return msg; Unsuccessfully

Faking data as below: msg.payload = [{ DATA : "01/01/2019", HORA : "23:30", SETPOINTAR1 : "AAA", SETPOINTAR2 : "BBB", TEMPERATURAAR1 : "123", TEMPERATURAAR2 : "456" }, { DATA : "02/02/2020", HORA : "24:30", SETPOINTAR1 : "XXX", SETPOINTAR2 : "YYY", TEMPER…

Hello Andrei. I think these are the data [{"DATA":[51,48,47,48,52,47,50,48,49,57],"HORA":[49,48,58,50,49],"SETPOINTAR1":[51,48,46,48,48],"SETPOINTAR2":[50,50,46,48,48],"TEMPERATURAAR1":[50,55,46,53,48],"TEMPERATURAAR2":[49,55,46,55,48]},{"DATA":[51,48,47,48,52,47,50,48,49,57],"HORA":[49,49,58,50,4…

Your dataset got modified when you pasted/copied the data from the debug panel. The data type changed from buffer to array. I, therefore, would need to do an additional transformation to recover your original dataset. I did a real quick testing and found out that the function you are looking for i…

Node-RED

Node-RED Forum

UI-Template DataBase Help

General

Andrei 16 May 2019 18:38 17

I stumbled upon this post while searching for something else...

Perhaps it can bu useful for your purpose.

Topic		Replies	Views
Sending Data from file in node to a dashboard table Dashboard	27	8828	3 April 2021
UI Template Edit msg.payload then Output Dashboard node-red-dashboard , ui-template	9	672	23 March 2024
How to auto detect payload using UI template General	14	1242	16 September 2021
UItemplate to template node (string output) Dashboard function-node , dashboard-2 , ui-template	1	170	14 April 2024
Send payload of array to UI-Template Table Dashboard	14	2490	6 October 2022

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-Template DataBase Help

Related topics