Page Properties Report: display other standard page properties

[Anton Kozhin]

Hi,

I'm exploring options to build simple reports on which pages were created and by whom and I'm currently looking at Page Properties Report macro. It works OK, but seems to be restricted only to columns I have set up in Page Properties macro, page Title, Creator and Modified timestamp. Is there any way to display other standard page properties like Created timestamp, who Modified, etc?

When I try to name these in "Columns to Display" it just adds blank columns (I believe it expects them to be in Page Properties macro). I know that "Created" property exists as I use it as a sorting criteria.

Thank you

[Brant Schroeder · Accepted solution]

@Anton Kozhin Welcome to the Atlassian community

You are correct that it needs to be part of the page properties.  You can review how the page properties report works here: https://support.atlassian.com/confluence-cloud/docs/insert-the-page-properties-report-macro/ 

[Anton Kozhin]

Thanks, @Brant Schroeder.

I checked the doco before, but that didn't help as it doesn't mention explicitly that only Page Properties macro fields are supported, although a few standard fields are still provided.

I was a bit disappointed that you can't use the standard properties that are already there and need to make users input them manually.

[Henning Steinhorst]

We include macros in the page properties table to get those values. Typically the page properties are set up only once in a page template, so nobody has to edit them (at least not all of them).

In the picture, I included 3 macros to populate the properties. Unfortunately the standard macros of confluence are rather limited here. We use the Scriptrunner addon which comes with that page info macro in the last row. You can use it to display a hand full of infos from a confluence page. Scriptrunner is a very handy addon that allows us to create custom macros to get almost every info that we need. However, there are other addons that offer useful macros in the marketplace.

Another caveat is performance of your reports. Especially in the cloud versions, there is a ton of cloud-to-cloud requests that would just be a (single) SQL-query in a sane architecture. The page property report gets all the pages, then each page runs several macros to get the info. it takes a while (some minutes for our bigger reports) to get the property report on screen.

[Anton Kozhin]

Hi @Henning Steinhorst 

Thanks for the insights provided, that's an interesting approach. I agree that the standard capabilities of Confluence are very limited for now. I will take a note of the addon you mentioned. Thanks again.