Referencing data in mango's (derby) sql database
-
I am trying to find a way to utilize certain datapoints in a history. i.e. I want to recall a certain data point's value at a certain date in time in the past and compare it to current datapoints.
I am assuming I need the sql datasource and that I need to connect to the Derby sql database within Mango.Can anyone assist me a little further with this???
Thanks for the help!!
-
Check out the Meta Data Source, I'm pretty sure that it has the functions you are looking for. The SQL module is meant to connect to an external database. With the Meta Data Source you can return the value of a point from the history and also apply scripts to its along with many other features.