How do I fetch the content of another page in a macro?

[Patrick Richter]

I've got a few hundred confluence pages that have a table with cells that hold a "last review date" and the "person responsible" for the page.

I'm now trying to create a macro that creates a central table with

• the name of the page
• the person responsible (not author!)
• the last review date (not modification date!)
• of all pages which have a last review date more than a year ago

I've found a way to do that with the last modification date and author using this answer, but in my case, that's not sufficient - modifying a date does not mean it has been fully reviewed, and the author might very well not be responsible anymore.

Looking through the examples and documentation on user macros, I've not found anything that specifically shows how to fetch content from other pages. I'd greatly appreciate it if someone has an example or even points me in the right direction.

My environment:

• Confluence 6.3.3
• I've got full administrative rights
• All pages in the space can be modified to achieve this

[Christopher Jaksch]

Hi @Patrick Richter

did you already try the following two macros?

* Page Properties Macro: https://confluence.atlassian.com/doc/page-properties-macro-184550024.html

* Page Properties Report Macro: https://confluence.atlassian.com/doc/page-properties-report-macro-186089616.html

On each page you use the page properties macro. On the central page you use the page properties report macro.

Hope that helps!

Best wishes
Chris (STAGIL)

[Patrick Richter]

Thanks for your response!
I'm aware of these macros and I'm using them for other things, but I'm not too sure how I could filter the results so that only pages with a review more than a year ago are displayed. Any Idea on how to do that?

[Christopher Jaksch]

Hi @Patrick Richter,

not quite sure if it works but you could try using the table filter add-on for Confluence on top of the page properties report macro: https://marketplace.atlassian.com/plugins/com.stiltsoft.confluence.plugin.tablefilter.tablefilter/server/overview

Please refer to the following answer aswell, as it states that it's working: https://community.atlassian.com/t5/Marketplace-Apps-questions/Does-table-filter-work-with-Page-Report-Properties/qaq-p/132047

Let me know if it works for you!

Best wishes
Chris (STAGIL)

[Patrick Richter]

Thanks again for your response, very much appreciated.

Right now, I'd like to avoid purchasing additional add-ons as long as I'm not sure I can't solve this with a macro.