Get data point names from MySQL data base
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,
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.