How can I display all the rows from a page properties macro using the page properties report

[Hazem Ajlani]

I have 2 filtered tables under page properties. I am displaying some of the information in another page using page properties report. The page properties report only shows the first row of each filtered tables and the heading. 

[Katerina Rudkovskaya _Stiltsoft_]

Hi @Hazem Ajlani, 

To collect multiple-row tables, you may use our app that is Table Filter and Charts for Confluence.

Replace your Page Properties/Page Properties Report macros with our Table Excerpt/Table Excerpt Include macros. They work similar to the standard macros (consider labels, provide page source metadata, etc.) but allow you to combine multiple-row tables into one big report.
Furthermore, you’ll be able to filter and aggregate the result table.

[Robert Keiper _K15t_]

Hey @Hazem Ajlani 

if you are a heavy user of page properties, you might want to check out my company's app Orderly Databases, which we consider "Page Properties on Steroids", it also allows you to reference all rows of multiple databases (our equivalent to the pp report macro) on a single page.

It's free for up to 10 users.

Cheers,
-Robert

[Diego]

Hi Hazem! Currently, the Page Properties Report Macro only shows the first line of a table.
The ideia behind it is that using the reports you would have key values with corresponding names that you could use somewhere else.
However, to "trick" this, you could:

1. Insert the the Page Properties Macro
2. Create a table with only two rows (one being the title/header)
3. Create a nested table in the second row
4. Insert this in your Page Properties Report Macro

Doing this should show the entire table within the first line. Here is my example:

This is the result:

Let us know if this helps your case!

[Hazem Ajlani]

Thanks for your help. 

Unfortunately I'm not able to create nested tables, "nested tables are not supported".

I'm using Confluence Cloud, not sure if that makes a difference. 

Any other thoughts? 

Thanks again

[Javier Vallaure]

I have the same problem, I cannot create nested tables. Is there any other "trick"?

[Hazem Ajlani]

 used a combination of the Excerpt macro and the page properties macro 

[Javier Vallaure]

Actually, I managed to include a nested table by clicking on the merge button on the content cell that you want the nested table.

[Hazem Ajlani]

Oh alright. Great!

[Tevan Alexander]

Thanks @Hazem Ajlani! 

To other users wanting to embed tables from subpages on a parent page, this was my scenario:

1. Parent listing page

2. 30 subpages in that folder with a table from each of those pages that I wanted to display on the parent page

Wrapping the table on each subpage with an Excerpt macro and then showing all of those tables on the parent page using the Excerpt Include macro got me the result I was looking for.

[MrMusicMan]

In 2022, displaying rows from page properties (instead of columns) is actually super easy, but the documentation is out of date.

To use page properties vertically:

1. Use the ➕  icon and search for "Page Properties, or type `/Page Properties` on your document.
2. Insert a table using the table Icon
    
3. Remove the last column
4. When hovering over the table, click the `Table Options` dropdown
   
5. Uncheck `Header row` and check `Header column`
6. Place your property keys in the first column, and your property values in the right column
7. Bonus: Ensure you've properly labeled your document, and that your page property report is looking for this same label.

Your Page Properties Report will now treat keys written in your first column as column headers.