Hi guys, a new user to node-red here. How do I query MySQL in node-red like e.g. I just want a normal chart for the number of times a certain event triggers and display it in a chart? I have the query ready, but I am not too sure on how to display it on the chart, the injected nodes has been replyi…

The only issue i see is you are attempting tp put msg.payload from the mySQL select directly into a chart and a ui text. If you look at the output of the mySQL node you will see it is an array - a chart expects the value to display to be in msg.payload and the topic to be the name of the series (th…

Query MySQL and displaying it in a dashboard Chart

General

Jack123 3 May 2021 06:12 3

For the top flow, I have tried writing MQTT message to the database, so its saving data to MySQL.

for the bottom flow, what I am currently trying to achieve is to just hoping the program returning me a value, and able to display it on the dashboard.

Note : All this are just for testing purposes

Regads,

Jack

Topic		Replies	Views
Display line chart with data retrieved from mysql Dashboard node-red-dashboard , database , function-node	7	68	8 February 2025
How could I display data from a mysql database within a chart? Dashboard node-red-dashboard	25	2972	19 July 2022
How can I show the chart from my data? General	13	287	18 August 2023
MYSQL query data is not displaying on line chart in dashboard Dashboard node-red-dashboard , database , chart	7	339	23 October 2022
Inserting data in chart Dashboard database	4	516	18 December 2021

Query MySQL and displaying it in a dashboard Chart

Related topics