I'm trying to read data from sqlite db previously storage with sqlite node then process that info to chart it in node red. I been read the following info but I don't quite understand what type of node red file I would need to use to retrieve such a data. Stored data To display a complete chart…

@zenofmud Yes, Sir ! With your last suggestion the chart is now working !!! I'm gonna analyze the changes to comprehend them. I don't like using something without understanding it and repeating it as a parrot. :smile: Than you very much for your time

@spyder0552 Hi I tried your suggestion, I got some payload but really my background with Jsonata is not strong and really I'm a little be lost. This is my partial flow to get some stored value in the db, based on selection of the start day and the end day . [Seletct a historical parameter] …

So you are going to plot the entire set of rows returned. First off, the date/time fieild is a text string (sqlite does not have a date format) that you need to change back to a javascript date (google 'w3schools date'). Secondly you need to build the array of data to be sent - see the Stored Data …

Hi thank you for your suggestion. I get what you said regarding the time, I'm using UTC time in ms now. I sow the examples on the link you sent me but a question remind. I sow the different data format but I do not have idea how to processes my data to get those format for the chart. I woul…

[image] NODE777: Would you help me with that? Be glad to help you. So what have you tried? Can you show how you are building the payload to match what it shows in the link I pointed you to?

Well, I did partially my assignment :slight_smile: I reached the point where a have the data structure to inject to chart but I got stuck trying to convert to JSON format the chart "y" values . One remark is that I have no intention to chart so many point in time when I 'm using the pick date…

Thanks for the answer. This is the code corresponding to the flow I already posted before. [{"id":"7dfd9399.1514dc","type":"tab","label":"Flow 8","disabled":false,"info":""},{"id":"e790367.f6ec3c8","type":"ui_date_picker","z":"7dfd9399.1514dc","name":"Start date2","label":"stday2","group":"e54364…

I see one issue right away. As soon as you pick eithor date, a msg will go thru the moment nodes and into the function node and the function node will build the SQL statement based on only one date and what ever the previous global date was. so you should: disconnect the moment nodes from the fun…

Hi Please see attached modified flow as you required it: [{"id":"7dfd9399.1514dc","type":"tab","label":"Flow 8","disabled":false,"info":""},{"id":"e129f2f9.10385","type":"ui_date_picker","z":"7dfd9399.1514dc","name":"Start date2","label":"stday2","group":"e5436490.b53788","order":1,"width":"0","he…

We are going to work thru this bit by bit. With that in mind: Why do you have a json node after the sqlite node? If you put a debug node on the change node after the join node, what do you see? is what you see correct (compare it to the example)

Node-RED

Node-RED Forum

From sqlite to json format

General

zenofmud 1 March 2020 21:58 12

Please read this then export your flow and attach it to a reply.

Topic		Replies	Views
Help with messaging on sqlite DB to dashboard chart Dashboard node-red-dashboard	10	594	10 May 2022
Node-Red / sqlite / Charts General	17	2336	8 May 2021
SQLITE data to Charts - Various Issues General database	12	2168	10 January 2022
How To Make Logging Data Values in Chart General	39	8200	26 November 2018
I need help, chart-ui from select sql server Dashboard	34	2034	7 June 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.

From sqlite to json format

Related topics