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.
Get data point names from MySQL data base
-
Dear All,
I am trying to get the mappings from data point IDs (e.g.
DP_123456') to data point names (e.g.DC_U'). I am using a MySQL data base and browsed the tables therein, but I could only find the names for the data source, not for individual points. If there was a `name' column with the data point names then I could query for that. Where is this mapping information stored?Thanks and Best Regards,
Michael Bach -
You'll need to use import/export. The data point name is serialized into the blob field in the dataPoints table.
-
Thanks for the answer. Just so that I am not drawing wrong conclusions: To get the name of a data point, I have to query for his xid (e.g. DP_123456) to get the blob and deserialize this blob in some way as part of that will contain the name.
I think I asked the wrong question. My goal is to query the data point values by its name. Ideally, the data point name would have an entry similar to data source tables. Currently, I see no way around to get there. Or is there even any?
I already experimented to deserialize the blob files from inside my programming interface, but the db package does not support blobs atm.