Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.
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
-
Hi mrcardenasp,
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
