How to display all the 'saved for later' entries for a specific space
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. 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.
1
2
3
4
5
6
7
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.
Was this helpful?