Can I create a table that shows data from child pages on the parent page?

[Bill Blinn]

I've been asked to create a parent page that will have a series of child pages with detailed information about events. The request includes the ability to extract specific information from the child pages (start date, clearance date, cause) for use in a table on the parent page.

The child pages will contain large amounts of descriptive text that should not be included on the parent page.

The Content Report Table doesn't do what I need and using Excerpt and Excerpt Include would be painful for the user.

I found https://community.atlassian.com/t5/Confluence-questions/How-to-aggregate-the-contents-of-certain-section-of-a-page-on/qaq-p/314436, which describes a macro. This might work, but I am not a system administrator. Is it possible for a space administrator to add such a macro to a specific page?

Or is there a better option that I'm missing?

Thanks!

[Christo Mastoroudes _Adaptavist_ · Accepted solution]

The system admin will have to create the macro, but once it is created any user with page edit permission should be able to use the macro on the page.

The tricky bit might be to pull exactly the information you want from those child pages. The proposed solution on the link you provided looks ok, but also requires the same unique label for each page in the page hierarchy. It might be possible to just get all the decendants instead of searching for pages with labels.

[Arushi Verma]

I'm using Include Excerpt Macro for achieving this by creating "Excerpts" on child pages and then including them in the Main page

[Bill Blinn]

Thanks. For now we'll have to use a manual process. If one of the system managers ever has time, perhaps we can automate it.