Hey everyone, I have the following flow: [11%20PM] GPS Tracker provides data, change node changes keys into Worldmap format, Insert that data into a Mysql db and plot on Worldmap. Works no problem. I want to read the db records in descending order from the DB based on time and plot the data on …

How often is the data in the database updated? That sql statement will only ever return 1 row so if no daa is updated or added, it will return the same row every time it is run

Put a debug node showing the output of the inserting db node and capture a successful insert followed by the result of the inject where it does not show the latest sample. Post it here so we can see.

and take out your limit statement and see if more are returned

Slight distraction I know, but if you included the name in the query and it was in the result array you could just send the array to the map as received.

Reading GPS data from MySQL to plot on World map

General

Greenprotocol 16 April 2019 03:15 3

The data input can be much quicker than the inject node.

There is always data recorded.

I cannot figure out how to iterate through the records that a currently in the db.

Topic		Replies	Views
WorldMap Issue - JSON-DB General	3	529	11 October 2018
Worldmap GPS tracking Dashboard	26	8605	23 May 2020
Timestamp synchroniziation in database General database	8	403	17 November 2023
MYSQL query data is not displaying on line chart in dashboard Dashboard node-red-dashboard , database , chart	7	376	23 October 2022
Data from MySQL db to Graph Dashboard	16	1729	2 December 2020

Reading GPS data from MySQL to plot on World map

Related topics