How to find out which pages will be affected by Retention Job Rules
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
Find out the pages that will be affected by the Data Retention Job.
When this job is executed (either soft or hard) all pages, attachments, and trash items that match the rule will be automatically deleted and purged.
Environment
Confluence
Diagnosis
Postgres database query to find out which pages/versions will be affected by the retention job:
1
2
3
select title,contenttype, content_status, version, creationdate, lastmoddate
from content
where contenttype ='PAGE' and content_status = 'current' and and lastmoddate > (CURRENT_DATE - INTERVAL '60 days') and version > 1;Solution
Typically retention job will delete any page that meets the criteria for deletion. The above query can be helpful to view which pages will be affected before configuring the rules.
Was this helpful?