Retrieving Page Created Information in Page Properties Report

[Craig_Harley]

I am using Page Properties Report to retrieve information on close to 1000 pages and I have requirements to also include

1. Date the page was first created
2. Date of last change
3. Who made the last change

Requirements 2 and 3 are relatively straight forward, but is there a way to return the Date Created value for a page?

thanks in advance

[Stiltsoft support]

Hi @Craig_Harley ,

As you are our customer and do have the Table Filter, Charts & Spreadsheets for Confluence app (judging by the previous questions), you may switch to the Table Excerpt/Table Excerpt Include macros instead (that is if you haven't already set 1000 Page Properties macros - then it will be time consuming to replace them).

The Table Excerpt Include macro allows you to show various types of metadata:

• Source page title
• Parent page title
• Space title
• Space key
• Labels
• Source page excerpt (abstract)
• Author
• Last modifier
• Created
• Updated
• Page version
• Page ID

[Craig_Harley]

this is useful to know, but struggling a little as have never used this before

i've dropped my page properties report into the table excerpt

but when i add the table excerpt include it only returns the date of when i created the page properties report

all the macros are on the same page

[Stiltsoft support]

The Table Excerpt serves as a substitute for the Page Properties macro - just replace it for all the tables that you need to collect. The only difference is that you need to assign the same name for your Table Excerpts. For example, "report".

Then go to the page where you have your Page Properties Report macro. Insert the Table Excerpt Include macro instead. Go to the macro settings, type in the name of your Excerpts ("report" for our example), select the Excerpt source (as you've used Page Properties Report, you may choose Pages with labels and type in the already given label that you've used before), choose the required Page metadata and tick the Show as a report option.

[Stiltsoft support]

What you are trying to do works correctly but doesn't make any sense: you have a table created by the standard Page Properties Report. Let's assume it's on the Page A.

Then you just reuse this table on the same page.

As the Table Excerpt Include macro shows info gathered from the pages with Excerpts, it shows you all the info about the same Page A. If you move your Table Excerpt Include to the page B, the metadata will still be pulled only from the page A.

But as you need to pull it not from the page with the Page Properties Report but from all the pages with the Page Properties macros, you need to replace all Page Properties with Table Excerpts as I've described before.

[Craig_Harley]

ah, this is going to be a mammoth task then

I have page properties on all of my pages already which is then pulled into a page properties report and combined with a Jira table within the table toolbox macro

[Stiltsoft support]

Yes, unfortunately, it will be a long task to switch all the macros.

But you may keep such possibility in mind for other projects. Here is a table with comparison between our macros and standard: https://docs.stiltsoft.com/tfac/cloud/comparison-with-native-page-properties-report-excerpt-include-macros-188614456.html#ComparisonwithnativePagePropertiesReport/ExcerptIncludemacros-TableExcerpt/TableExcerptIncludevsPageProperties/PagePropertiesReport

For example, Page Properties Report collects only one-row tables. If you put several-row table in the Page Properties macro, only the first data row will be pulled through. Other rows will be ignored.

Our Table Excerpt Include macro pulls the whole table that may come in handy in various cases.

[Jayesh Raghuvanshi]

@Craig_Harley 

You can get details from Analytics , see below screenshot

[Craig_Harley]

thanks for this, but how would i be able to pull this into a page properties report?