# ui-uPlot- Chart from Stored Data-MySql- Moved to Grafana + iframe now

**URL:** <https://discourse.nodered.org/t/ui-uplot-chart-from-stored-data-mysql-moved-to-grafana-iframe-now/75685>\
**Category:** Dashboard\
**Created:** [24 February 2023 12:40 UTC](https://discourse.nodered.org/t/ui-uplot-chart-from-stored-data-mysql-moved-to-grafana-iframe-now/75685 "2023-02-24T12:40:04Z")\
**Posts on this page:** 15\
**Page:** 1

<div class="post-metadata">

**Author:** ![smanjunath211](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/smanjunath211/32/95742_2.png) [@smanjunath211](https://discourse.nodered.org/u/smanjunath211)\
**Post date:** [24 February 2023 12:40 UTC](https://discourse.nodered.org/t/ui-uplot-chart-from-stored-data-mysql-moved-to-grafana-iframe-now/75685/1 "2023-02-24T12:40:04Z")

</div>

Continuing the discussion from [[Beta] node-red-contrib-ui-uPlot-charts](https://discourse.nodered.org/t/beta-node-red-contrib-ui-uplot-charts/52758/14):

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.

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/d/7/d7425fdf6b66e2b0542656380aca7cf7889ee847.png)

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

```auto
[{"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"]]}]

```

---

<div class="post-metadata">

**Author:** ![dynamicdave](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dynamicdave/32/96_2.png) [@dynamicdave](https://discourse.nodered.org/u/dynamicdave)\
**Post date:** [24 February 2023 14:00 UTC](https://discourse.nodered.org/t/ui-uplot-chart-from-stored-data-mysql-moved-to-grafana-iframe-now/75685/2 "2023-02-24T14:00:07Z")

</div>

Is 'uplot-charts' a Node-RED node as I can't find it in the flows library??  
Is it a HA node??

---

<div class="post-metadata">

**Author:** ![smanjunath211](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/smanjunath211/32/95742_2.png) [@smanjunath211](https://discourse.nodered.org/u/smanjunath211)\
**Post date:** [25 February 2023 00:45 UTC](https://discourse.nodered.org/t/ui-uplot-chart-from-stored-data-mysql-moved-to-grafana-iframe-now/75685/3 "2023-02-25T00:45:16Z")

</div>

`npm i node-red-contrib-ui-uplot-charts`

I could not install it from pallete. the above install script is given in the link that i have provided in my first post. also there is some discussion about this in the linked post, but i could not understand much of it.

---

<div class="post-metadata">

**Author:** ![Paul-Reed](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/paul-reed/32/66906_2.png) [@Paul-Reed](https://discourse.nodered.org/u/Paul-Reed)\
**Post date:** [25 February 2023 08:43 UTC](https://discourse.nodered.org/t/ui-uplot-chart-from-stored-data-mysql-moved-to-grafana-iframe-now/75685/4 "2023-02-25T08:43:22Z")

</div>

@Christian-Me is this your contrib-node?

---

<div class="post-metadata">

**Author:** ![smanjunath211](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/smanjunath211/32/95742_2.png) [@smanjunath211](https://discourse.nodered.org/u/smanjunath211)\
**Post date:** [27 February 2023 10:32 UTC](https://discourse.nodered.org/t/ui-uplot-chart-from-stored-data-mysql-moved-to-grafana-iframe-now/75685/5 "2023-02-27T10:32:23Z")

</div>

I am open to use any other chart node which can allow ZOOM in / out of the graph and allow to chart from a database. I am able to use FlexDash time series chart but then i have to cmpletely switch to FD dashboard. the chart node in the regular dashboard does not allow zooming in on chart. (at least as far as i understand)

---

<div class="post-metadata">

**Author:** ![smanjunath211](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/smanjunath211/32/95742_2.png) [@smanjunath211](https://discourse.nodered.org/u/smanjunath211)\
**Post date:** [8 March 2023 16:30 UTC](https://discourse.nodered.org/t/ui-uplot-chart-from-stored-data-mysql-moved-to-grafana-iframe-now/75685/6 "2023-03-08T16:30:07Z")

</div>

Bringing this topic up since i am stuck and not getting much help researching the forum/web for this issue.

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [8 March 2023 16:46 UTC](https://discourse.nodered.org/t/ui-uplot-chart-from-stored-data-mysql-moved-to-grafana-iframe-now/75685/7 "2023-03-08T16:46:12Z")

</div>

> [@smanjunath211](#):
>
> I could not install it from pallete

I don't understand, you said in the first post that you installed it and the examples work perfectly.

---

<div class="post-metadata">

**Author:** ![smanjunath211](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/smanjunath211/32/95742_2.png) [@smanjunath211](https://discourse.nodered.org/u/smanjunath211)\
**Post date:** [8 March 2023 17:09 UTC](https://discourse.nodered.org/t/ui-uplot-chart-from-stored-data-mysql-moved-to-grafana-iframe-now/75685/8 "2023-03-08T17:09:59Z")

</div>

I was answering to daves question. I was able to install but not from node red editor. Examples work fine too. But the examples are a like for live data. I am unable to plot from data from a database.

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [8 March 2023 17:17 UTC](https://discourse.nodered.org/t/ui-uplot-chart-from-stored-data-mysql-moved-to-grafana-iframe-now/75685/9 "2023-03-08T17:17:25Z")

</div>

> [@smanjunath211](#):
>
> I am unable to plot from data from a database.

I think you will need input from the author. You could submit an issue on the [node's github page](https://github.com/Christian-Me/node-red-contrib-ui-uplot-charts/issues).

---

<div class="post-metadata">

**Author:** ![smanjunath211](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/smanjunath211/32/95742_2.png) [@smanjunath211](https://discourse.nodered.org/u/smanjunath211)\
**Post date:** [8 March 2023 17:27 UTC](https://discourse.nodered.org/t/ui-uplot-chart-from-stored-data-mysql-moved-to-grafana-iframe-now/75685/10 "2023-03-08T17:27:27Z")

</div>

Looks like @Christian-Me is not active in forum since over an year.

---

<div class="post-metadata">

**Author:** ![smanjunath211](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/smanjunath211/32/95742_2.png) [@smanjunath211](https://discourse.nodered.org/u/smanjunath211)\
**Post date:** [10 March 2023 01:15 UTC](https://discourse.nodered.org/t/ui-uplot-chart-from-stored-data-mysql-moved-to-grafana-iframe-now/75685/11 "2023-03-10T01:15:03Z")

</div>

The purpose i am looking at other chart nodes is to get the 'zoomable' option in a line graph. the built in ui-chart node in dashboard has no such feature. i have tried _flexdash_ and it works, but i am forced to move the entire dashboard to FD just for one feature. I do have a FD dashboard for another instance running. Grafana is also an option, but that is again going away from dashboard. i am currently studying how to get grafana in to dashboard, but currently it is looking like a daunting task

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [10 March 2023 09:15 UTC](https://discourse.nodered.org/t/ui-uplot-chart-from-stored-data-mysql-moved-to-grafana-iframe-now/75685/12 "2023-03-10T09:15:43Z")

</div>

You can run grafana in an iframe I believe.

---

<div class="post-metadata">

**Author:** ![smanjunath211](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/smanjunath211/32/95742_2.png) [@smanjunath211](https://discourse.nodered.org/u/smanjunath211)\
**Post date:** [10 March 2023 10:15 UTC](https://discourse.nodered.org/t/ui-uplot-chart-from-stored-data-mysql-moved-to-grafana-iframe-now/75685/13 "2023-03-10T10:15:48Z")

</div>

Yes, I am on the same path now, but as i said, i need to get familiar with grafana first and then bring it into dashboard.

Is it difficult to get the zoom option with a template node ?

---

<div class="post-metadata">

**Author:** ![smanjunath211](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/smanjunath211/32/95742_2.png) [@smanjunath211](https://discourse.nodered.org/u/smanjunath211)\
**Post date:** [11 March 2023 08:57 UTC](https://discourse.nodered.org/t/ui-uplot-chart-from-stored-data-mysql-moved-to-grafana-iframe-now/75685/14 "2023-03-11T08:57:08Z")

</div>

Successfully imported grafana into my NR dashboard through i-frame

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [25 March 2023 08:57 UTC](https://discourse.nodered.org/t/ui-uplot-chart-from-stored-data-mysql-moved-to-grafana-iframe-now/75685/15 "2023-03-25T08:57:18Z")

</div>

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