I'm using a sql statement msg.topic='SELECT HOUR(Time) as Htime, Temperature FROM `temp-at-interrupt` where minute(Time)= "00" order by Date DESC, Time DESC LIMIT 20'; which returns the following structure: array[20] [0 … 9] 0: object Htime: 19 Temperature: 83.33 1: object Htime: 18 Tempera…

Try use in node.warn(“x=“+x) in your function

Also you appear to be trying (and failing) to create a JSON string representing the object you want and then converting it to an object. It is generally much easier just to build the javascript object directly, then you don't have all that messing about with strings which, as you have found out, is…

Zenofmud: Thanks for the suggestion. node.warn and node.error did help. Collin: Advice taken I will rewrite the function. Thanks to you both.

Node-RED

Node-RED Forum

Sql to chart coding error

Dashboard

system Closed 3 May 2020 13:37 5

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Dashboard 2 multiple line from sql database Dashboard dashboard-2	33	354	16 January 2026
Sql to ui-chart for temperature Dashboard function-node	16	277	4 December 2024
Help with messaging on sqlite DB to dashboard chart Dashboard node-red-dashboard	11	561	24 May 2022
Problem in Chart sensor data General	8	1266	30 May 2020
Inserting database data into a chart Dashboard	7	3112	27 June 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.

Sql to chart coding error

Related topics