Continuing the discussion from [Beta] node-red-contrib-ui-uPlot-charts:
Hi, i installed and got the examples working perfectly. I need to draw the chart with stored data in a database, (MySql) but could not find any information in the forum or on web. what is the syntax and format to be used to feed uplot chart
@Christian-Me sorry for tagging, please help if you can spare some time. thanks.
I have datetime and Value1, Value2 field in MySQL database.
I have included a data set from MySQL in an inject node, i know it is not the right syntax, please let me know how to modify the syntax to suit ui-uPlot chart node
[{"id":"7d4c0bd95af778d0","type":"inject","z":"f1df79916dde251a","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"[{\"Time\":\"24-02-2023 18:07\",\"m\":25},{\"Time\":\"24-02-2023 18:06\",\"m\":25},{\"Time\":\"24-02-2023 18:05\",\"m\":25},{\"Time\":\"24-02-2023 18:04\",\"m\":25},{\"Time\":\"24-02-2023 18:03\",\"m\":25},{\"Time\":\"24-02-2023 18:02\",\"m\":25},{\"Time\":\"24-02-2023 18:01\",\"m\":25},{\"Time\":\"24-02-2023 18:00\",\"m\":25},{\"Time\":\"24-02-2023 17:59\",\"m\":25},{\"Time\":\"24-02-2023 17:58\",\"m\":25},{\"Time\":\"24-02-2023 17:57\",\"m\":16},{\"Time\":\"24-02-2023 17:56\",\"m\":3},{\"Time\":\"24-02-2023 17:55\",\"m\":25},{\"Time\":\"24-02-2023 17:54\",\"m\":25},{\"Time\":\"24-02-2023 17:53\",\"m\":25},{\"Time\":\"24-02-2023 17:52\",\"m\":25},{\"Time\":\"24-02-2023 17:51\",\"m\":25},{\"Time\":\"24-02-2023 17:50\",\"m\":25},{\"Time\":\"24-02-2023 17:49\",\"m\":25},{\"Time\":\"24-02-2023 17:48\",\"m\":25}]","payloadType":"json","x":2280,"y":3480,"wires":[["e368192a78fb0111"]]}]