Confluence Support
Documentation, knowledge base.
- View account
- View requests
Jira Software
Project and issue tracking
Jira Service Management
Service management and customer support
Jira Work Management
Manage any business project
Document collaboration
Git code management
Usage and admin help
Answers, support, and inspiration
Suggestions and bugs
Feature suggestions and bug reports
Marketplace
Product apps
Billing and licensing
Frequently asked questions
- Log in to account
- Contact support
- Training & Certification
- Cloud Migration Center
- GDPR guides
- Enterprise services
- Atlassian partners
- User groups
- Automation for Jira
- Atlassian.com
- View in Confluence
- Manage Viewport
- Space Directory
- People Directory
- Page Properties Macro
- Advanced Roadmaps Macro
- Anchor Macro
- Attachments Macro
- Blog Posts Macro
- Change History Macro
- Chart Macro
- Cheese Macro
- Children Display Macro
- Code Block Macro
- Column Macro
- Content by Label Macro
- Content by User Macro
- Content Report Table Macro
- Contributors Macro
- Contributors Summary Macro
- Create from Template Macro
- Create Space Button Macro
- Excerpt Include Macro
- Excerpt Macro
- Expand Macro
- Favorite Pages Macro
- Gallery Macro
- Global Reports Macro
- HTML Include Macro
- IM Presence Macro
- Include Page Macro
- Info, Tip, Note, and Warning Macros
- Jira Chart Macro
- Jira Issues Macro
- Labels List Macro
- Livesearch Macro
- Loremipsum Macro
- Multimedia Macro
- Navigation Map Macro
- Network Macro
- Noformat Macro
- Office Excel Macro
- Office PowerPoint Macro
- Office Word Macro
- Page Index Macro
- Page Properties Report Macro
- Page Tree Macro
- Page Tree Search Macro
- Panel Macro
- Popular Labels Macro
- Profile Picture Macro
- Recently Updated Dashboard Macro
- Recently Updated Macro
- Recently Used Labels Macro
- Related Labels Macro
- Roadmap Planner Macro
- RSS Feed Macro
- Search Results Macro
- Section Macro
- Space Attachments Macro
- Space Details Macro
- Spaces List Macro
- Status Macro
- Table of Contents Macro
- Table of Content Zone Macro
- Task Report Macro
- Team Calendar Macro
- User List Macro
- User Profile Macro
- View File Macro
- Widget Connector Macro
On this page
Related content.
- No related content found
Still need help?
The Atlassian Community is here for you.
Ask the community
When used together, the Page Properties and Page Properties Report macro can be used to create a table of information drawn from multiple pages.
These macros are great for:
- Decision registers
- Status reports
- Policy and procedure documentation
In short anywhere you have several distinct pieces of information you want to be able to roll-up, and cross-reference in a table on another page.
To use this macro, you need to add a Page Properties macro on one or more pages, and then you can add a Page Properties Report macro on another page, as shown below.
On this page:
Related pages:
- Decisions Blueprint
- Product Requirements Blueprint
Screenshot: A project page with status information presented in a Page Properties macro.
Screenshot: A page with a Page Properties Report macro showing status information from the Page Properties macro on several different project pages.
You can see examples of these two macros in action in the Decisions and Product Requirements blueprints.
Add this macro to your page
There are quite a few steps involved to set up this macro correctly, but once it's done, it's very easy to copy the macro to other pages, or add it to a template.
To add the Page Properties macro to a page:
- Choose Page Properties from the Confluence content category.
- Choose Insert.
- In the macro body create a two column table
- In the left column list your 'properties' – these will be the column headings in your report table.
- Apply the Heading column style to the left column - this will indicate to the Page Properties Report macro that these are your properties.
- In the right column list the value for each property – these will populate the rows in your report table
- Save your page.
- Add a label to your page - you'll need to specify this label in the page properties report macro
Next you need to add the Page Properties Report macro to a different page.
Screenshot: The Page Properties macro on a page in the editor, with a vertical layout.
Page properties layout options
Horizontal or vertical layout.
You can choose to arrange the properties in your table vertically or horizontally. Just make sure you apply the Heading row or Heading column style to your properties, to tell the Page Properties Report macro, where to find them.
Here's an example of a horizontal layout.
Screenshot: The Page Properties macro on a page in the editor with a horizontal layout.
Hidden or visible
You can choose whether the contents of the Page Properties macro should be visible when someone views the page.
This is useful when the information isn't relevant to everyone. For example if you're using this macro to track when a policy was last reviewed and approved, you may only want that info to be visible on the page containing the Page Properties Report macro, not the page itself.
Screenshot: Configuring the Page Properties macro to be hidden.
Using multiple Page Properties macros on one page
You can add multiple Page Properties macros on a single page, and choose whether to include all or only specific macros in the report. You might use multiple macros because you want the information in the macro to display in context with the rest of the page, or because you want to be able to report on individual Page Properties macros separately.
The Page Properties macro includes an optional ID parameter that can be used to identify specific Page Properties macros.
To show the contents of all Page Properties macros in the report:
- Add a label to the page containing the Page Properties macros
- Specify this label in the Page Properties Report macro
To show the contents of selected Page Properties macros in the report:
- Specify an ID in the Page Properties macro that you want to report on
- Specify both the label and ID in the Page Properties Report macro
Note: The Page Properties Report macro can only accept one page label, and one ID.
See the Page Properties macro in action in How to document product requirements in Confluence . This powerful macro lets you create a summary page that pulls in information from multiple pages.
Change the macro parameters
Macro parameters are used to change the behaviour of a macro.
To change the macro parameters:
- Update the parameters as required then choose Insert .
Here's a list of the parameters available in this macro.
Limitations
- You can't use macros in the left column as the data in this column is used to populate the column headings in your Page Properties Report macro.
- It is not possible to reference the metadata using the metadata key from within the page, or anywhere else on a Confluence page.
- There's a known issue where the macro does not work correctly when placed inside an expand macro, which is inside a panel macro. See CONFSERVER-59594 - Getting issue details... STATUS .
Other ways to add this macro
Add this macro as you type.
Add this macro using wiki markup
You can't use wiki markup to add this macro.
Was this helpful?
Confluence Support
- Documentation
Set up Confluence Cloud
Get the high-level details you need to set up your Confluence Cloud site in order to meet your team's needs.
Create and organize work in Confluence Cloud
Learn how to create great content and organize it.
Collaborate on content and get notified in Confluence Cloud
Learn how to collaborate on pages and blogs, get notified about activity, and view analytics to see how content is performing.
Manage your account and permissions in Confluence Cloud
Adjust settings around who can see what content on your site and what actions they can perform on it.
Administer Confluence Cloud sites
Find everything a site admin needs to know to keep their Confluence Cloud site running smoothly.
Extend the functionality of Confluence Cloud
Get an overview of the macros and premium features that extend Confluence functionality.
Answers, support and inspiration
System Status
Cloud services health
Suggestions and bugs
Feature suggestions and bug reports
Marketplace
Product apps
Billing & licensing
Frequently asked questions
- Log in to account
- Contact support
- Training & Certification
- Atlassian Migration Program
- GDPR guides
- Enterprise services
- Atlassian Partners
- Success Central
- User groups
- Automation for Jira
- Atlassian.com
Insert the page properties macro
The Page Properties and Page Properties Report macro work together to show summary information from one page on another page. You can see examples of these two macros in action in the Decisions and Product Requirements blueprints.
Use the Page Properties macro
To add the Page Properties macro:
When editing, select from the toolbar
Find the macro by name and select it
Configure it as needed
You can also type / on the page to bring up the same list you'd see by selecting from the toolbar. Continue typing the name of the macro to filter the list.
In the macro body create a two column table:
In the left column, list your 'keys' – these will be the column headings in your report table
In the right column, list the value for each key – these will populate the rows in your report table
Add a label to your page (you'll need to specify this label in the page properties report macro)
Save your page.
Use the Page Properties Macro horizontally
To do this:
Create a two row rather than two column table, and ensure the first row has the heading row style applied.
List your keys in the first row, and values in the second row.
The Page Properties Report Macro will be able to pull this information accurately even if you're using the Page Properties Macro vertically elsewhere.
Next you need to add the Page Properties Report macro to another page.
Here's an example of the Page Properties macro when editing. Deadline, Current Status, and Team will be column headings in the report.
Here's what the example above will look like in the Page Properties Report.
Use multiple Page Properties macros on one page
You can add multiple Page Properties macros on a single page, and choose whether to include all or only specific macros in the report. You might use multiple macros because you want the information in the macro to display in context with the rest of the page, or because you want to be able to report on individual Page Properties macros separately.
The Page Properties macro includes an optional ID parameter that can be used to identify specific Page Properties macros.
To show the contents of all Page Properties macros in the report:
Add a label to the page containing the Page Properties macros
Specify this label in the Page Properties Report macro
To show the contents of selected Page Properties macros in the report:
Specify an ID in the Page Properties macro that you want to report on
Specify both the label and ID in the Page Properties Report macro
The Page Properties Report macro can only accept one page label, and one ID.
See the Page Properties macro in action in How to document product requirements in Confluence . This powerful macro lets you create a summary page that pulls in information from multiple pages.
To edit the Page Properties macro:
Select the macro placeholder.
Select the Edit icon to open the configuration panel.
Configure the parameters. Your changes are saved as you go.
Resume editing the page, and the panel closes.
You can also select the centered , medium-width , and full-width icons to adjust the width of some macros. Select the trashcan icon to remove the macro.
Parameters are options that you can set to control what and how content from the macro appears on the page.
If the parameter name used in Confluence Cloud storage format or wikimarkup is different than the label used when inserting macros using the browser or the slash command, it will be listed below in brackets ( example ).
You can't use macros in the left column as the data in this column is used to populate the column headings in your Page Properties Report macro.
It is not possible to reference the metadata using the metadata key from within the page, or anywhere else on a Confluence page.
Was this helpful?
Additional Help
- Use macros to add reporting info to Confluence pages
- Insert the page properties report macro
- Insert the user list macro
How to Use Page Properties Macros in Atlassian Confluence
by Boris Berenberg | Apr 30, 2019
Adopting Confluence
Confluence spaces are set up – Check. You structured your page trees – Check. Only key stakeholders can view your sensitive information through space permissions and page restrictions – Check. Information that was once in silos is now available to the right people – Check. Gone are the days when employees searched for key information in email and Google drive. The office is buzzing with excitement about how easy it is to collaborate and how great it is to have a single place for all company information. Users are updating content and creating new content daily, if not hourly. Confluence adoption is an organization-wide success. But then it happens…
“How can I see all of my projects’ information in one place, at a glance?” “When I search for ‘Project ABC’ status I get over 20 results, and I can’t find the right page!” “Which project deadline is the earliest?”
Frequently Overlooked Macro Solution
How to use these macros.
Macros within the Macro
Modus Create Expands Atlassian Services and Expertise with Atlas Authority Acquisition
May 11, 2022 | Company news
With the acquisition of Atlas Authority, Modus Create will further expand its team of Atlassian experts and certifications.
Financial Companies and the Cloud: 5 Trends
Apr 28, 2022 | Confluence , Jira
Spurred by the pandemic, financial companies have accelerated digital transformation, including cloud computing. Among many benefits, cloud technology helps financial companies meet the evolving needs of consumers and lower infrastructure costs. In the Atlassian world...
Techsplaining Vs. Human-Centric System Administration
Apr 12, 2022 | Confluence , Jira , Work better
Effective Atlassian administration requires us to look beyond technical requirements and understand the human aspect.
Table Filter and Charts with Page Properties Report
Atlassian Confluence is a powerful and feature-rich platform for content management. The system and its built-in macros provide a comfortable space for collaboration among different teams. And using third-party apps, you can up the productivity and use Confluence to its full potential.
We start a series of video tutorials that will help you master Confluence and incorporate it into your everyday work.
Our first tutorial shows you the way to generate reports on specific page properties in Confluence. It also teaches you to filter, aggregate, and transform the data after creating the Page Properties report.
Confluence Page Properties and Page Properties Report macros
On any Confluence page, you can insert the Page Properties macro that allows you to define one or multiple properties to the page. These properties are placed within the specifically formatted table. The Page Properties Report macro further pulls these properties (the so-called metadata) from pages having specific labels and generates a table listing these properties.
This may be convenient when you deal with the pages storing similar content. With this macro, you can keep some information that can be further used for filtration or visualization.
The easiest way to use the Confluence Page Properties macro on your page is to create a blueprint and place the table with metadata and text hints there. This way, whenever a user creates a new page with a template, you will have the same data. That will keep consistency for all the pages based on the same blueprint.
To generate a content report, you need to create a page with the Page Properties Report macro. After that, select one or multiple page labels against which the list of pages will be generated.
Once you save the page, the macro generates the list of pages with metadata.
Learn more about using Spreadsheets in Confluence
Table Filter and Charts for Confluence with Page Properties Report
When you get a long list of data, you may find it useful to filter the content. The Table Filter and Charts for Confluence app will be a good tool to apply to Page Properties Report in this case.
This app allows you to:
- filter table data in many ways, choosing the most suitable filters
- generate pivot tables aggregating data against the specific parameters
- output charts and graphs visualizing your data series
Want to know how it works? Check out the video for key details.
Page properties report: sort by number of likes or comments
- Resolution: Unresolved
- Component/s: Comments - Comments Editor , Macros - Page Properties , Page - Reactions
- Macros-Page-Properties-Page-Properties-Report
- affects-server
- editor-macros
Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy .
Description
NOTE: This suggestion is for Confluence Cloud . Using Confluence Server ? See the corresponding suggestion .
In the page properties report macro, I would like to able to sort the listed pages by the number of likes or by the number of comments. I want to be able to set this sorting as the default sorting. Alternatively, I want to be able to sort the generated table by the number of likes or comments by clicking the respective column.
Attachments
Issue links.
- Gathering Interest
Ask a question
Start a discussion.
- Jira Jira Software
- Jira Service Desk Jira Service Management
- Jira Work Management
- Confluence Confluence
- Trello Trello
Community resources
- Announcements
- Technical support
- Documentation
Atlassian Community Events
- Atlassian University
- groups-icon Welcome Center
- groups-icon Featured Groups
- groups-icon Product Groups
- groups-icon Regional Groups
- groups-icon Industry Groups
- groups-icon Community Groups
- Learning Paths
- Certifications
- Courses by Product
Get product advice from experts
Join a community group
Advance your career with learning paths
Earn badges and rewards
Connect and share ideas at events
- Can't Configure Page Proeprties Report
Can't Configure Page Proeprties Report
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Suggest an answer
Still have a question?
Get fast answers from people who know.
Was this helpful?
Deployment type, product plan, permissions level.
- confluence-cloud
- page-properties-report
- Community Guidelines
- Privacy policy
- Notice at Collection
- Terms of use
- © 2024 Atlassian
IMAGES
VIDEO
COMMENTS
LEFT JOIN T2 ON T2.'Status' = T1.'Status'. ORDER BY T2.'Ordering'. This will map the ordering column onto the data table, allowing you to use it for sorting, but without displaying it. Here, T1 is the first table (Page Properties Report) and T2 is the second table (The one that maps status to order number) This is an example of my status ...
To add the Page Properties Report macro to a page: In the editor, choose Insert > Other Macros > Page Properties Report. Enter the Labels you want to report on - this is the label added to pages containing the Page Properties macro. Further narrow down your search by adding more fields, or specifying a Page Properties ID (more info on this ...
Using the Page Properties Report Sort option, can I sort on 2 fields? Chris Freeman May 10, 2019. I figure this may be a limit on functionality, or maybe I just don't have the proper syntax, but I have a PPR that displays Title, Phase, and Status. I want to sort by Phase, then Title. I tried Phase, Title. I tried Phase|Title, (Phase ASC, Title ...
1 answer. In your page properties table have one section for priority. Choose a numerical system of priority (i.e 1-5) or alphabetical system of priority (i.e a,b,c). When you go to your page properties report you can sort the heading priority and it should do so in alphabetical order. Unfortunately if you use normal priority levels like 'high ...
To add the Page Properties Report macro to a page: In the editor, choose Insert > Other Macros > Page Properties Report. Enter the Labels you want to report on - this is the label added to pages containing the Page Properties macro. Further narrow down your search by adding more fields, or specifying a Page Properties ID (more info on this ...
To add the Page Properties macro to a page: From the editor toolbar, choose Insert > Other Macros. Choose Page Properties from the Confluence content category. Choose Insert. In the macro body create a two column table. In the left column list your 'properties' - these will be the column headings in your report table.
Create or edit a regular Confluence page and embed the Property Group Report macro: In the Confluence editor, choose + > Other Macros. Find and select the Property Group Report macro. The macro dialog opens up. Select a previously created property group you want to generate a report for. On the right side of the macro dialog you can see a live ...
"Sort by" doesn't work at all when the column heading has a capital letter in it. When you use lower-case characters sorting is doing something but the order isn't good. This problem lower significantly the value of the "Page Properties Report" macro.
Use the Page Properties Macro horizontally . To do this: Create a two row rather than two column table, and ensure the first row has the heading row style applied.. List your keys in the first row, and values in the second row. The Page Properties Report Macro will be able to pull this information accurately even if you're using the Page Properties Macro vertically elsewhere.
The Page Properties and Page Properties Report macros are built-in Confluence macros that work together with one another to provide highly useful functionality to many different teams and for many different use-cases.. In a nutshell, these two macros work in conjunction with one another to allow summary information from tables on multiple Confluence pages within a space (using the page ...
To use these macros you must first create a page with a table on it. In the left column of your table insert the headings you would like to appear on the index page. Try to use only the most important information that summarizes the contents of the page. The table on your input page should look something like this: You must also include a label ...
Step 1: Add Page Properties macro to a page. 1. First, create a Confluence page with a table. In the left column of the table, add the headings that will later be seen on the index page. What is now organized vertically here will later be displayed horizontally in the Page Properties Report.
8. Add a label to your page - you will need to specify this label in the page properties report macro. 9.Save your page. Do this process for a few subsequent new pages. After that, go to a existing page and choose Insert > Other Macros > Page Properties Report. Input the string "Name" into "Title column heading". Input "Name" in "Sort by ...
Unlock the potential of Confluence with our step-by-step guide on creating Page Properties Reports. In this comprehensive video tutorial, we walk you through...
In this video, you'll learn how to filter, aggregate, and analyze data generated by Page Properties Report as well as build dynamic charts and graphs on the ...
Page properties report macro is not sorting DD/MM/YYYY in the proper order; that is, going by month year first, then month, then day. Instead, it is sorting in alpha-numeric order. Environment. Confluence; Page Properties Macros 4.3.1; Steps to Reproduce. Create a few pages with a table including a date in one column with typing //
Answer accepted. Page Properties Report macro supports sorting by a single column only. You can use Table Filter macro to sort by multiple columns . We don't have the Table Filter macro here. Is there another approach that might work? I'm afraid I don't know any other existing solutions.
Learn how to create and enhance standard reports in Confluence. Start with the Page Properties and Page Properties Report macros to show summary information ...
1 answer. For starters, the Sort by property in this macro has a long history of problems. I have never found/figured out a list of what you can natively sort by. The default is modified date. If you check the Show likes count box in the report configuration, the number of likes shows up in the report without a heading.
Daniel Vlad February 13, 2024. Hello, I create pages using a BluePrint that saves one or more labels and metadata when saving. In the page view, the macro: "Page properties report" the pages are displayed in a table with the metadata/labels as columns. 1st Problem sorting: If the page contains more than one value as metadata, the sorting for ...
The Table Filter and Charts for Confluence app will be a good tool to apply to Page Properties Report in this case. This app allows you to: filter table data in many ways, choosing the most suitable filters. generate pivot tables aggregating data against the specific parameters. output charts and graphs visualizing your data series.
In the page properties report macro, I would like to able to sort the listed pages by the number of likes or by the number of comments. I want to be able to set this sorting as the default sorting. Alternatively, I want to be able to sort the generated table by the number of likes or comments by clicking the respective column.
Page properties report macro is not sorting DD/MM/YYYY in the proper order; that is, going by month year first... The Page Properties Report macro, bundled with Confluence, allows you to compile reports of metadata stored by the Page Properties macro on pages and blog posts which have workflows applied...
Can't Configure Page Proeprties Report. I use Confluence at work, and I've set up a free space at home to organize info for a small project. I'm using a page properties report, and it's providing the default presentation just fine. However, if I try to use any of the 'advanced' options (Title Column header, Order Columns, Sort by Column) the ...