Page Drop Down is blank in the Dashboard Designer or Edit Pages

June 19th, 2020


This is a known issue that can occur. The following instructions will allow you to restore your page list.

Go to the SQL Console and run the following command

select * from jsonData where XID = 'mangoUI-pages'

Pages SQL

Note the ID of the row with XID mangoUI-pages

Go to Administration > System Status > Audit Trail

Filter Type = Json data and find the 2nd most recent record with the id from the SQL Console

Screenshot 2017-12-21 12.24.26.png

Click on the message to see the popup of the Json content. It might not be the 2nd most recent but find the most recent that contains the list of pages in the Json. Copy the Json content and past into a text editor.

Screenshot 2017-12-21 12.24.51.png

You need to remove all the "\" from the content which can be done with find and replace the \ with nothing.

Screenshot 2017-12-21 12.25.19.png

Select and copy just the content between the two [ ]

Screenshot 2017-12-21 12.26.17.png

Go to Administration > JSON Store

Screenshot 2017-12-21 12.22.54.png

Edit the item with XID mangoUI-pages

Screenshot 2017-12-21 12.23.37.png

Past in the pages from the text editor in between the two [ ]

Screenshot 2017-12-21 12.26.37.png

Click SAVE and refresh your pages and your pages should all show up in the Dashboard Designer and Page Editor

Copyright © 2020 Radix IoT, LLC.