• 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 3 Documentation Website Mango 4 Documentation Website Mango 5 Documentation Website

    is there a way to restore a deleted dashboard ?

    Dashboard Designer & Custom AngularJS Pages
    2
    4
    1.1k
    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.
    • B
      bhr477
      last edited by

      Hi,
      I'm new to the system and I've been experimenting with it trying to learn and how i can apply it to my facility.
      while trying to delete a component in my dashboard designer I've deleted the whole page, is there a way to restore it ?
      Appreciate the help

      1 Reply Last reply Reply Quote 0
      • phildunlapP
        phildunlap
        last edited by

        Hi bhr477, welcome to the forum!

        Yes! Your dashboard can be recovered, so long as the audit events of its previous saves have not been purged from the audit table.

        1. Use SQL console to find the ID by looking through the context to find if that's the deletion event (changeType 3, where 1 is create and 2 is modify)
          select objectId, context from audit where typename='JSON_DATA' and changeType=3 order by id desc limit 10;
        2. Create a new dashboard in the dashboard designer and save it
        3. Find the ID of the new entry in the jsonData table via SQL
          select id, name, data from jsonData order by id desc limit 5;
        4. Use the SQL console to change the ID of the new entry in the JsonData table to the objectId we found in step 1.
          update jsonData set id=[objectId from step 1] where id=[id from step 3];
        5. Reload the dashboard designer page, and use the revert tool to recover the deleted dashboard!

        0_1562953156163_dashboardRevision.png

        1 Reply Last reply Reply Quote 0
        • B
          bhr477
          last edited by

          thank you so much :D
          It worked and i got it back

          1 Reply Last reply Reply Quote 0
          • phildunlapP
            phildunlap
            last edited by

            Glad to hear it! :D

            1 Reply Last reply Reply Quote 0
            • First post
              Last post