# Help with messaging on sqlite DB to dashboard chart

**URL:** <https://discourse.nodered.org/t/help-with-messaging-on-sqlite-db-to-dashboard-chart/62309>\
**Category:** Dashboard\
**Tags:** node-red-dashboard\
**Created:** [6 May 2022 18:34 UTC](https://discourse.nodered.org/t/help-with-messaging-on-sqlite-db-to-dashboard-chart/62309 "2022-05-06T18:34:03Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![NRdiscrs9393](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/nrdiscrs9393/32/726_2.png) [@NRdiscrs9393](https://discourse.nodered.org/u/NRdiscrs9393)\
**Post date:** [10 May 2022 12:27 UTC](https://discourse.nodered.org/t/help-with-messaging-on-sqlite-db-to-dashboard-chart/62309/9 "2022-05-10T12:27:10Z")

</div>

This is working for the selection of a single Node/Sensor. However, the flow joins the DB output when multiple items are selected, thus creating an array of data. I've found a similar post here [Dynamic series identification from message, send data to Chart - #5 by Steve-Mcl](https://discourse.nodered.org/t/dynamic-series-identification-from-message-send-data-to-chart/36682/5); however, the output is different.

My apologies for creating more work. Your help is greatly appreciated.

> [[{"{"sqlupdate":"2022-05-09 11:33:11","Epoch":1652095991966,"Node":"node201","Sensor":"dev50","Value":63.95},{"sqlupdate":"2022-05-09 11:49:18","Epoch":1652096958122,"Node":"node201","Sensor":"dev50","Value":63.95},{"sqlupdate":"2022-05-09 12:05:24","Epoch":1652097924381,"Node":"node201","Sensor":"dev50","Value":63.95}],[{"sqlupdate":"2022-05-08 12:28:23","Epoch":1652012902971,"Node":"node220","Sensor":"dev48","Value":60.91},{"sqlupdate":"2022-05-08 12:44:17","Epoch":1652013857123,"Node":"node220","Sensor":"dev48","Value":62.56},{"sqlupdate":"2022-05-08 13:00:14","Epoch":1652014814346,"Node":"node220","Sensor":"dev48","Value":64.36},{"sqlupdate":"2022-05-08 13:16:08","Epoch":1652015768491,"Node":"node220","Sensor":"dev48","Value":66.51},]]

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/f/cfc6a3cc39da006eac42a50e1ca56d6c52b1e383.png)

---

_[View the full topic](https://discourse.nodered.org/t/help-with-messaging-on-sqlite-db-to-dashboard-chart/62309)._