Map dashboard from MySQl data geofenced
I have the information of several geolocated assets (latitude, longitude) in a mysql table which is already connected as Data Source to Mango, the goal is to make a query in mysql with different criteria (query) and according to the data obtained display them in a geographical map (google maps). In what way (api?) Did the query to mysql and how did the loop to travel the data obtained and mark them on a map. Thank you
There is not a way through the API to do a constructed query in the MySQL data source and then return the result set. That's probably a good idea, but for now you'd have to load your data into Mango through the SQL data source on an ongoing basis, then use something like our RQL to restrict the set of points that are making it to the map.
I recently helped this person get many values for the same point from their MySQL table into Mango. Maybe it is useful: https://forum.infiniteautomation.com/topic/3115/sql-data-source-query/2