Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,463,370
Community Members
 
Community Events
176
Community Groups

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

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?

5 answers

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.).

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.

0 votes

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.

0 votes
Brant Schroeder Community Leader Jan 08, 2022

@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/

0 votes
Pramodh M Community Leader Jan 07, 2022

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

1.png

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

2.png

Thanks,
Pramodh

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events