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.