Showing Recently Updated Pages in a Table

Let's show what pages have recently been updated in the Confluence instance and display them in a table. Let's also show who created the updated pages and who modified them by displaying their avatar image.

Ingredients

Guide

  1. Create a Report Table macro.
    Set the Maximum Results parameter to "5".

  2. Within the Report Table, create a Content Reporter macro.
    Set the Spaces parameter to "@all".
    Set the Type parameter to "pages".
    Set the Time Period parameter to "30d".

  3. Within the Content Reporter macro, create a Date Sort macro.
    Set the Key to "content:modification date" and the Order to "descending".

  4. Under the Content Reporter macro, but within the Report Table macro, create a Report Column macro.
    For the Title parameter, type in "Page Title".

  5. Within the Page Title Report Column macro, create a Report Info macro.
    For the Key, type in "content:title" and check Link To Item.
     
  6. Under the Page Title Report Column macro, and still within the Report Table macro, create another Report Column macro.
    For the Title parameter, type in "Space".

  7. Within the Space Report Column macro, create a Report Info macro.
    For the Key, type in "content:space" and check Link To Item.

  8. Under the Space Report Column macro, and still within the Report Table macro, create another Report Column macro.
    For the Title parameter, type in "Created".

  9. Within the Created Report Column macro, create a Report Info macro.
    For the Key, type in "content:creation date" and check Link To Item.
     
  10. Under the Created Report Column macro, and still within the Report Table macro, create another Report Column macro.
    For the Title parameter, type in "Updated".

  11. Within the Updated Report Column macro, create a Report Info macro.
    For the Key, type in "content:modification date" and check Link To Item.
     
  12. Under the Updated Report Column macro, and still within the Report Table macro, create another Report Column macro.
    For the Title parameter, type in "Author".

  13. Within the Author Report Column macro, create a Report Image macro.
    For the Key, type in "content:creator > user:picture".
     
  14. Under the Author Report Column macro, and still within the Report Table macro, create another Report Column macro.
    For the Title parameter, type in "Modifier".

  15. Within the Modifier Report Column macro, create a Report Image macro.
    For the Key, type in "content:modifier > user:picture".

  16. You should now have something that looks like this:




  17. Now click Save and check out the results.


Notes

The report-image macros use a special kind of Key that looks like this: "content:modifier > user:picture".

These are called Keychains and they string together Keys to provide the macro more data from Suppliers for Reporting.

For more information on Keychains, view the Supplier Keychains page.

Result

Page TitleSpaceCreatedUpdatedAuthorModifier

 How does the Connector securely access Salesforce data?

Connector for Salesforce & Jira

 18 Jan 2021

18 Jan 2021

 How to format Dates and Numbers using Report info macro?

Scaffolding Forms & Templates

 25 Dec 2020

18 Jan 2021

 Latest Highlights - Dec 2020

New Landing Page

 18 Jan 2021

18 Jan 2021

 Running an association report

Connector for Salesforce & Jira

 14 Nov 2018

15 Jan 2021

 Multiple labels behaviour with Match All

Visibility for Confluence

 21 Dec 2020

14 Jan 2021