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. 

page properties report confluence sort by

Screenshot: A page with a Page Properties Report macro showing status information from the Page Properties macro on several different project pages.

page properties report confluence sort by

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:

page properties report confluence sort by

  • 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 report confluence sort by

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. 

page properties report confluence sort by

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.

page properties report confluence sort by

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:

page properties report confluence sort by

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

page properties report confluence sort by

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.

See how to edit the Page Properties macro for use in a Page Properties Report macro

Here's what the example above will look like in the Page Properties Report.

See how the details of a Page Properties macro get pulled into the Page Properties Report macro

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

Atlas Authority

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.

page properties report confluence sort by

Macros within the Macro

page properties report confluence sort by

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

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

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.

page properties report confluence sort by

Table Filter and Charts with Page Properties Report

page properties report confluence sort by

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.

A page with a Page Properties Report table

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.

A table located inside the page properties macro

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.

A preview of a Page Properties Report table

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.

A dashboard based on the Page Properties report table

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

page properties report confluence sort by

Want to know how it works? Check out the video for key details.

page properties report confluence sort by

Page properties report: sort by number of likes or comments

page properties report confluence sort by

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

Suggestion -

  • Gathering Interest

Unassigned

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

questions

Get product advice from experts

groups

Join a community group

learning

Advance your career with learning paths

kudos

Earn badges and rewards

events

Connect and share ideas at events

  • Can't Configure Page Proeprties Report

Can't Configure Page Proeprties Report

Ron Smith

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

People on a hot air balloon lifted by Community discussions

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

  1. Page Properties Macro

    page properties report confluence sort by

  2. Table Filter and Charts with Page Properties Report

    page properties report confluence sort by

  3. Interactive Page Properties Reports in Confluence Cloud

    page properties report confluence sort by

  4. page properties report confluence sort by

    page properties report confluence sort by

  5. Heading sorting on Page Properties Report worked

    page properties report confluence sort by

  6. page properties report confluence sort by

    page properties report confluence sort by

VIDEO

  1. Responsive Real State Landing Page Website Using HTML CSS & JavaScript

  2. Atlassianトーク|Confluence ページプロパティ・プロパティレポート

  3. Confluence Magazine

  4. E-plan Tutorial part 2 in Tamil

  5. Page Properties

  6. Easy Heading Macro for Confluence Cloud

COMMENTS

  1. Sort Page Properties Report by status

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

  2. Page Properties Report Macro

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

  3. Solved: Using the Page Properties Report Sort option, can

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

  4. Page properties report sort options

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

  5. Insert the page properties report macro

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

  6. Page Properties Macro

    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.

  7. Generating Automated Property Group Reports

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

  8. "Sort by" function in "Page Properties Report" macro doesn't work

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

  9. Insert the page properties 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.

  10. Using the Page Properties and Page Properties Report macros

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

  11. How to Use Page Properties Macros in Atlassian Confluence

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

  12. How to use Page Properties Macros in Confluence

    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.

  13. "Page properties report" macro can only be sort using "title"

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

  14. How to Create a Page Properties Report in Confluence

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

  15. Page Properties Report with Table Filter and Charts for Confluence

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

  16. Page properties report doesn't sort by date properly

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

  17. Solved: Multi-column sort in page properties report macro

    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.

  18. Reports in Confluence (Part 1 of 3): Page Properties and Page

    Learn how to create and enhance standard reports in Confluence. Start with the Page Properties and Page Properties Report macros to show summary information ...

  19. Page properties report sort by likes?

    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.

  20. Page properties report

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

  21. Table Filter and Charts with Page Properties Report

    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.

  22. Page properties report: sort by number of likes or comments

    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.

  23. page properties report confluence sort by

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

  24. Can't Configure Page Proeprties Report

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