• Recent
    • Tags
    • Popular
    • Register
    • Login

    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 4 Documentation Website Mango 5 Documentation Website Radix IoT LinkedIn

    Get data point names from MySQL data base

    Scheduled Pinned Locked Moved User help
    4 Posts 2 Posters 3.1k Views 1 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • M Offline
      moinmoin
      last edited by

      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

      1 Reply Last reply Reply Quote 0
      • M Offline
        mlohbihler
        last edited by

        You'll need to use import/export. The data point name is serialized into the blob field in the dataPoints table.

        Best regards,
        Matthew

        1 Reply Last reply Reply Quote 0
        • M Offline
          moinmoin
          last edited by

          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.

          1 Reply Last reply Reply Quote 0

          Hello! It looks like you're interested in this conversation, but you don't have an account yet.

          Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

          With your input, this post could be even better 💗

          Register Login
          • First post
            Last post