I have the following flow:
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 Worldmap.
I have set up an inject node to inject every 5 seconds and Query the DB for the latest record.
My SELECT QUERY is:
msg.topic = "SELECT time, lat, lon, speed, direction FROM TrackDB ORDER by time DESC LIMIT 1";
I receive this object:
The next trigger produces the same record, not the next one in sequence.
I've read the forum over and over to find out what I'm doing wrong, to no avail.
Any help is greatly appreciated.