How to return more than the first row in a Page Properties Report

[Caitlin Barahimi]

I am trying to aggregate rows of data from multiple pages in confluence to a master page in confluence using Page Properties and Page Properties Report, but the master page with the Page Properties Report macro only displays the first row of information form the multiple pages with the Page Properties macro.

Is there a setting I am missing to pull in all of the data from the pages with the Page Properties macro onto the page with the Page Properties Report or a different macro I should be using?

[Katerina Kovriga _Stiltsoft_]

Hi @Caitlin Barahimi ,

The Page Properties/Page Properties Report macros collect one-row tables.

To collect multiple-row tables along with the source pages' metadata, you may need 3rd party apps. For example, we can suggest our Table Filter and Charts for Confluence add-on and its Table Excerpt/Table Excerpt Include macros.

Besides these handy pair of macros, you'll be able to filter, aggregate and visualize your tables as well as performing tabular calculations (including not only manually created Confluence tables but macro generated, for example, Jira Issues, Page Properties Report, Content Report Table, etc.).

[Katerina Kovriga _Stiltsoft_]

Hi there,

As this Community question mentions our Table Filter and Charts for Confluence app, we are happy to introduce its new macro – Table Spreadsheet.

The macro allows you to work with fully functional Excel spreadsheets right in Confluence.

You’ll be able to use cells’ formulas, filters, conditional formatting, etc., create pivot tables and charts from the page view and edit mode.

The Table Spreadsheet macro is available for Cloud and Server/Data Center.

[Richard Davies]

I feel your pain.  I'm trying to do the same thing.  I have a number of design pages, each of which have a table that contains a number of line items of technical debt associated with that design.

I want to have a parent page that summarises all this information in a single table.

[Brant Schroeder]

@Caitlin Barahimi welcome to the Atlassian community 

When you are adding page properties to a page and you add your table you need to make sure you set the tables heading styling is applied to the first column.  If you do not do this the it will only get the first roe.  You can learn more here: https://support.atlassian.com/confluence-cloud/docs/insert-the-page-properties-macro/

[Pramodh M]

Hi @Caitlin Barahimi 

The data over rows in the pages where you have page property macro will be included as column data in the page property report macro

Check for the macro configuration whether you have restricted the columns

Include just the labels if you are restricting the pages from where your page properties report has to pick up those tables

You could change how the columns can be shown in the macro configuration page

Thanks,
Pramodh