How to display all the 'saved for later' entries for a specific space
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
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.
*Fisheye および Crucible は除く
要約
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.