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.
is there a way to restore a deleted dashboard ?
-
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 -
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.
- 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; - Create a new dashboard in the dashboard designer and save it
- 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; - 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]; - Reload the dashboard designer page, and use the revert tool to recover the deleted dashboard!
- 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)
-
thank you so much :D
It worked and i got it back -
Glad to hear it! :D
