Skip to main content
Skip table of contents

Sorting by date a report showing the latest modification to pages

Scenario

This recipe generates a report of modified pages and blogposts, and sorts them by the modified date.

You can copy and paste this code into the target Confluence page:

{
  "cql": "type=page OR type=blogpost order by lastModified asc",
  "expansions": "content.container,content.metadata,content.body,content.body.view,content.body.view.content,content.metadata.properties,content.ancestors,content.space",
  "tab": 0,
  "filters": [
    ""
  ],
  "reportInfos": [
    {
      "id": "7a5f55f4-fff6-41bb-87c1-72b579208cc7",
      "type": "basic",
      "title": "Space",
      "value": "content.container.name",
      "template": "{\"type\":\"doc\",\"version\":1,\"content\":[{\"type\":\"paragraph\",\"content\":[{\"type\":\"text\",\"text\":\"{{ content.container.name }}\"}]}]}",
      "attr": {
        "value": "content.space.name"
      }
    },
    {
      "id": "ca39c40b-0d47-47c8-b2a9-4bde924b3aff",
      "type": "basic",
      "title": "Content (Page or Blogpost)",
      "value": "content.title",
      "template": "{\"type\":\"doc\",\"version\":1,\"content\":[{\"type\":\"paragraph\",\"content\":[{\"type\":\"text\",\"text\":\"{{ content.title }}\"}]}]}"
    },
    {
      "id": "64fc9174-3ca3-4930-807e-e91c177679bf",
      "type": "basic",
      "title": "Last Modified",
      "value": "friendlyLastModified",
      "template": "{\"type\":\"doc\",\"version\":1,\"content\":[{\"type\":\"paragraph\",\"content\":[{\"type\":\"text\",\"text\":\"{{ friendlyLastModified }}\"}]}]}",
      "attr": {
        "value": "friendlyLastModified"
      }
    }
  ]
}

Result

Recipe

Apps


Reporting for Confluence Cloud


Level

Easy

Estimated time

5 minutes

Notes

This recipe is now part of Reporting's built-in templates. You can easily load it into your page by using the templates feature.

By default, the report is limited to 200 results. Enable Get all results below the search box if you need to view more results.

Caveats

  • The recipe above only shows pages and blogposts (as types of content).

  • The recipe can be tweaked to show other types of content. Be aware that the result set can be large if you have a lot of content in your instance.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.