How to display all the 'saved for later' entries for a specific space
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Sometimes we might need to move Confluence from one server to another. If we want to make sure that all the saved for later entries were properly moved, we can use the query below to compare between the old and the new server.
It will list all the saved for later entries for a specific space.
Solution
Run the following query against the old and new database of Confluence, to see if the saved for later entries were properly migrated.
SELECT UA.user_key, UA.username, CL.CREATIONDATE, CL.CONTENTID, C.TITLE, S.SPACEID, S.SPACENAME, S.SPACEKEY
FROM CONTENT_LABEL CL
JOIN CONTENT C ON CL.CONTENTID = C.CONTENTID
JOIN LABEL L ON L.LABELID = CL.LABELID
JOIN user_mapping UA ON UA.user_key = CL.OWNER
JOIN SPACES S ON S.SPACEID = C.SPACEID
WHERE C.CONTENTTYPE = 'PAGE' AND L.NAME = 'favourite' AND C.PREVVER is null AND S.SPACEKEY = 'ABC';
Make sure to adjust the S.SPACEKEY value.