Hi folks, i hope you can help me. I collect data in a mysql database. When i read out data, the payload is in that format: array[99] [0 … 9] 0: object date: "2024-02-10T23:00:00.000Z max_power: 0.52 1: object 2: object 3: object 4: object 5: object …

I use MS SQL but the output of the connection node is the same. I Work with the function node and use the following code (translate with your variables) var data=[]; var series= ["max_power"]; var labels = []; var labelX= ""; var labelY= ""; msg.payload.forEach(function(value) { data.push(val…

Hi, welcome to the forum. Here is an existing working demo [image] I need help, chart-ui from select sql server Dashboard Here is a dynamic solution that works for most SQL data arrays... I have adapted it to show you how it can work for you... [image] […

Note that the two examples above are for the original dashboard node-red-dashboard. There is a newer dashboard @flowfuse/node-red-dashboard. If that's the version you installed you'll need to search the forum for dashboard-2 examples from within the last year. The ones above won't work.

If you are using @flowforge-dashboad (Dashboard 2) then you do not need to format the sql return. Except I believe the timestamp has to be unix millisecond timestamp, which of course you can have the sql request return. Chart ui-chart | Node-RED Dashboard 2.0 If you are still using the Angular node…

[image] E1cid: If you are using @flowforge-dashboad (Dashboard 2) then you do not need to format the sql return. Except I believe the timestamp has to be unix millisecond timestamp, which of course you can have the sql request return Just emphasising this - use Dashboard 2.0 - the original Da…

Hallo Raffaele, you were right, it worked perfectly on Dashboard 1.0.Thanks

Dear Steve, thanks for your recommendations on posting into the forum.

Node-RED

Node-RED Forum

Creating a Chart from MSQL-Database

Dashboard

jbudd 12 August 2024 12:16 6

There is an example of SQL database (not specifically MSSQL) to Dashboard v1 chart here

Topic		Replies	Views
Create Chart from mySQL Data General	36	13762	9 August 2021
Data from mySQL to Chart General	8	3932	23 May 2019
Doubt with data from Mysql A NodeRed and graph it General node-red-dashboard , database , chart , mysql	8	255	14 July 2024
Chart Dashboard 2.0 Dashboard dashboard-2	13	322	1 July 2024
Chart from mysql node-red date to date Dashboard	2	417	16 July 2021

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.

Creating a Chart from MSQL-Database

Related topics