Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

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.

Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website Mango 5 Documentation Website

M

Topics created by Milton Cardenas

M

Map dashboard from MySQl data geofenced

Development general discussion
• • • Milton Cardenas

2

0
Votes

2
Posts

944
Views

P

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