Query Confluence Space Shortcuts in Database

[Kristin Lyons]

Does anyone know if there is a way to query all space shortcuts (on the sidebar) in the database across all spaces?

[Tobias Meyer]

Hi Kirstin

Please find more information here: https://confluence.atlassian.com/confkb/how-to-restore-space-shortcuts-after-import-from-xml-744721363.html

The query would be:

SELECT * FROM "AO_187CCC_SIDEBAR_LINK" WHERE "CATEGORY" = 'QUICK';