Search and export contents by status

Avatar
Gabor Dicso
Follow

Users would like to be able to generate reports on archived or expired pages and export them in a spreadsheet.

Have more questions? Submit a request

2 Comments

Date Votes
  • 0
    Avatar
    Robynn Powell

    That would be helpful to me also, in reporting to management to show improvement.

    Use case: Export expired pages report on day 1. At end of review period, export expired pages again to see what wasn't handled by reviewers.

  • 0
    Avatar
    Aron Gombas

    UPDATE: We have released the Better Content Archiving app's cloud version just a few weeks ago. It addresses many points criticized in the Data Center version, including also this one.

    (Our plan is that, if there is interest, we will back-port the most valuable changes from the Cloud version to the Data Center one.)

    In the cloud version we implemented several app features using CQL, the query language of Confluence, because structured query languages allow powerful filtering and searching.

    We also make several content properties, most importantly the content status, available as CQL fields. For example, you can write a simple query like this to get the expired pages in those two spaces:

    space in (FOO,BAR) and type=page and arch.status="Expired"

    You can run it with the CQL Search app, choose your columns, then just copy-paste the search results to an Excel spreadsheet. It is super-easy:

    Note that there are dedicated export feature ideas in our product roadmap, but the approach described above can already be used right now!

    🔥 Try this in action now!

    Edited by Aron Gombas
Please sign in to leave a comment.