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.
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.
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.