Confluence Page - Properties Report Multiple Rows Portable
In Confluence, the Page Properties Report macro is designed to display one row per page. If you need to show multiple rows for a single page, you must use specific workarounds or third-party apps, as the standard macro is intended for rolling up singular instances of metadata across multiple pages. Native Workarounds
If you do not have access to third-party apps, you can try these native structural changes: Multiple Page Properties Macros : You can add several Page Properties macros to a single page. If they share the same label, the Page Properties Report will display them as separate rows. Vertical Table Formatting Page Properties macro Insert a table and remove the last column. Table Options Header Row Header Column
The left column (Header Column) acts as your property names, and the right column contains your values. Nested Tables (Visual Trick)
: Place a single-row table inside the Page Properties macro, but create a nested table
within the value cell to display multiple data points in that single row. Advanced Solutions (Third-Party Apps)
For more robust reporting without manual restructuring, third-party apps provide specialized macros:
Workaround inside the Page Properties macro:
Inside the single “value” cell, you can write:
- Item 1
- Item 2
- Item 3
In list mode, the Page Properties Report will render these as a bullet list for that page. It’s still one row per page, but the row contains multiple lines.
Use case: Good for notes, comments, or bullet-point lists. Bad for structured data you want to sort or filter (e.g., by priority or date).
Conclusion
Confluence’s Page Properties Report is designed for unique metadata per page (One Page = One Report Row). If you need One Page = Multiple Report Rows, the native functionality fights against you. confluence page properties report multiple rows
The best practice is usually Strategy 1 (Flattening): Rename your rows to Item 1, Item 2, Item 3. While this makes your source table slightly more verbose, it results in a robust, sortable report that captures all your data without requiring expensive add-ons or switching to the Task Report system.
Confluence Page Properties Report: How to Display Multiple Rows
Confluence is a powerful collaboration platform that enables teams to create, share, and manage content. One of its most useful features is the Page Properties Report macro, which allows users to create a table that displays properties from multiple pages. However, one common limitation of this macro is that it only displays a single row of data. In this article, we'll explore how to display multiple rows in a Confluence Page Properties Report.
What is a Confluence Page Properties Report?
A Page Properties Report is a macro in Confluence that enables users to create a table that displays properties from multiple pages. This macro is useful for creating reports, dashboards, and other types of pages that require data from multiple sources. With a Page Properties Report, users can easily create a table that displays information such as page titles, authors, creation dates, and more.
The Limitation: Single Row Display
By default, the Page Properties Report macro only displays a single row of data. This can be limiting when you need to display data from multiple pages. For example, if you have a report that needs to display data from 10 different pages, you would need to create 10 separate Page Properties Report macros, each displaying a single row of data. This can be cumbersome and make your page look cluttered.
Solution: Using the Page Properties Report with Multiple Rows
So, how can you display multiple rows in a Confluence Page Properties Report? The solution involves using a combination of Confluence macros and some clever configuration. Here are the steps: In Confluence, the Page Properties Report macro is
Step 1: Create a Table on Each Page
To display multiple rows in a Page Properties Report, you need to create a table on each page that contains the data you want to display. This table should have a single row with the properties you want to display. For example, if you want to display the page title, author, and creation date, your table might look like this:
| Page Title | Author | Creation Date | | --- | --- | --- | | My Page | John Doe | 2022-01-01 |
Step 2: Add the Page Properties Macro
On each page, add the Page Properties macro to the table you created in Step 1. This macro will allow you to specify the properties that you want to display in the report.
Step 3: Add the Page Properties Report Macro
On the page where you want to display the report, add the Page Properties Report macro. This macro will allow you to specify the pages that you want to include in the report.
Step 4: Configure the Page Properties Report Macro
To display multiple rows in the report, you need to configure the Page Properties Report macro to use a specific layout. To do this, follow these steps: Workaround inside the Page Properties macro: Inside the
- In the Page Properties Report macro, select the Table layout.
- In the Table columns field, specify the columns that you want to display. For example, if you want to display the page title, author, and creation date, enter
Page Title, Author, Creation Date. - In the Rows field, select Multiple rows.
Step 5: Add Pages to the Report
To add pages to the report, click the Add pages button and select the pages that you want to include. You can select multiple pages by holding down the Ctrl key (Windows) or Command key (Mac).
Step 6: Save and View the Report
Save the page and view the report. The Page Properties Report macro should now display multiple rows of data, one for each page that you selected.
Tips and Variations
Here are some tips and variations to help you get the most out of the Page Properties Report macro:
- Use a template: If you have multiple pages with the same properties, you can create a template that includes the Page Properties macro and the table. This will save you time and ensure consistency across your pages.
- Use a query: If you have a large number of pages and want to display only a subset of them, you can use a query to filter the pages. For example, you can use a query to display only pages that were created in the last month.
- Customize the layout: You can customize the layout of the report by using CSS styles or by creating a custom template.
Conclusion
Displaying multiple rows in a Confluence Page Properties Report is a powerful way to create reports and dashboards that showcase data from multiple pages. By following the steps outlined in this article, you can create a report that displays multiple rows of data, making it easier to analyze and visualize your data. Whether you're a Confluence power user or just starting out, this article has provided you with the knowledge and skills to take your reporting to the next level.
The Core Limitation: One Page, One Row
To understand the solution, we must understand the mechanism. The Page Properties macro looks for metadata defined on a page. When the Page Properties Report macro scans that page, it maps the Rank (first column of your properties table) to the Value (second column).
Example Scenario: Imagine you are managing a "Team Skills Matrix." You have a page for "John Doe." On his page, you have a table listing three skills:
- Row 1: Java - Expert
- Row 2: Python - Intermediate
- Row 3: SQL - Beginner
When you run the report, the output will typically only show: John Doe | Java | Expert. The subsequent rows are ignored because the report structure expects a unique set of metadata keys per page.