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.
Creating data points for a postgresql data source
-
Hello all,
I created a data source on Mango successfully using postgresql connection. The table I am collecting data from is used to collect data from a historical database every 10 minutes and 300 data points. My next goal is to graph some of this data over time for specific point names. Where can I find the details on creating the data points for my source? I tried to follow the steps on video tutorials and help menu but that did not help.
Thanks,
-
@eksantrik your photo did not upload. I think you need to wait a few moments after the upload is 100% until you see the photo display in the preview.
-
Hi eksantrik,
Might you happened to have seen my post in this thread: https://forum.infiniteautomation.com/topic/3115/sql-data-source-query/2
It may have some relevant information / inspiration.
The connection between the SQL points is the 'column name' on the point. If 'Row-based query' is not checked on your data source, then the point will get the value in the value column if its column name matches the ID column. If you are doing a row-based query, then it's the first selected column contains the identifier.
