If you are just starting, try the first. If you need advanced data manipulation, explore the Atlassian Marketplace for filtering tools to take your reporting to the next level. *If you’d like, I can: Show you step-by-step screenshots of how to set this up. Give you a sample SQL query for the Table Transformer app. Compare the top 3 apps for advanced Confluence reporting.*
You can add multiple Page Property macros to a single page, each containing a different set of metadata. Then, use the Confluence Page Properties Report macro to display all the page properties.
This comprehensive guide covers how the Page Properties Report works, why it defaults to one row, and the exact workarounds you can use to display multiple rows of data seamlessly. Understanding the Core Limitation
Allows you to merge, filter, and aggregate standard Confluence tables from multiple pages, giving you total control over rows and columns. confluence page properties report multiple rows
Three rows, all linking back to the same Product Roadmap page.
: The report will then show one row for every macro found on that page. Note that if the macros share a common header, they may still be split into multiple rows in the report. Option 2: Restructure to Key-Value Pairs
By default, the report displays every metadata key it finds. In the Page Properties Report macro options, use the Columns to show field to explicitly list which headers you want to see, and in what order. If you are just starting, try the first
Have a unique use case? Share it in the Atlassian Community forums – the collective wisdom of Confluence admins is unmatched.
def response = new JsonSlurper().parse(apiUrl, 'GET', query)
Project Manager, Status, Due Date, Budget. Give you a sample SQL query for the Table Transformer app
The most reliable native method is to use a where the left column is the header (the "Key") and the right is the "Value". Insert the Page Properties macro. Create a table with two columns. Make the left column a Header Column .
On a single page, define a Page Properties macro with the following structure: