How can I export page version history details for a given space?
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
サーバー*製品のサポートは 2024 年 2 月 15 日に終了しました。サーバー製品を利用している場合は、アトラシアンのサーバー製品のサポート終了のお知らせページにて移行オプションをご確認ください。
*Fisheye および Crucible は除く
問題
An admin would like to export a simple page history with modification dates, name of last modifier, comments and the page version number for every page in a space. This export would be an export of the data that is seen when viewing <Confluence-Base-URL>/pages/viewpreviousversions.action?pageId=XXXX.
原因
Currently Confluence native functionality does not offer a way to export this history via the UI.
ソリューション
You can extract the page history details by running the following query on your database. Be sure to fill in the value of SPACE KEY before running the query.
SELECT um.username,
c.title,
c.version,
c.lastmoddate,
c.versioncomment,
c.contentid
FROM content c
JOIN user_mapping um
ON c.lastmodifier = um.user_key
WHERE ( c.prevver IN (SELECT contentid
FROM content
WHERE prevver IS NULL
AND contenttype IN ( 'PAGE', 'BLOGPOST' )
AND content_status = 'current'
AND spaceid IN (SELECT spaceid
FROM spaces
WHERE spacekey = '<SPACE KEY HERE>'))
AND c.content_status = 'current'
AND c.contenttype IN ( 'PAGE', 'BLOGPOST' ) )
OR ( c.prevver IS NULL
AND c.contenttype IN ( 'PAGE', 'BLOGPOST' )
AND c.content_status = 'current'
AND c.spaceid IN ((SELECT spaceid
FROM spaces
WHERE spacekey = '<SPACE KEY HERE>')) )
ORDER BY c.title,
c.version DESC
Depending on what type of database you are running, you may need to format this query differently.