How to display all the 'saved for later' entries for a specific space

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.

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';

(warning) Make sure to adjust the S.SPACEKEY value.

Last modified on Jan 22, 2021

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.