Listing open and resolved comments from each page in a space
Scenario
In this recipe, we'll build a report that lists the number of open and resolved comments in each page in a space.
Result
Recipe
Apps | Reporting for Confluence Server & Data Center |
---|---|
Level | Advanced |
Estimated time | 20 minutes |
Macros | And Filter, Content Reporter, Grouping Reporter, Report Column, Report Info, Report Table, Text Filter |
Suppliers | Collection Supplier, Comment Supplier, Page Supplier, Space Supplier |
Storage format
You can copy and paste this code into the Confluence Source Editor:
Not available.
Â
Macro structure
You can recreate the example in the editor view:
Steps
Create a Report Table macro.
Within the Report Table macro, create a Content Reporter macro and set Types to "page".Â
Inside the Content Reporter macro, create an And Filter macro.
Inside the And Filter macro add a Text Filter and set Key to
page:all comments>collect "inline-status"
and tick the Required checkbox.Add another Text Filter and set the following:
Key topage:all comments>collect "inline-status"
Exclude to .*Dangling.*
Tick the Required checkbox.Inside the Report Table macro, create a Report Column macro and set the Title to "title/page".
Within the Report Column macro, add a Report Info macro and set the Key to
page:title
and Link to True.Inside the Report Table macro, create a Report Column macro and set the Title to "# Open Comments".Â
Within the Report Column macro, add a Report Info macro and set the Key toÂ
page:all comments>collect "inline-status">join with " ">find "Open">size
Inside the Report Table macro, create a Report Column macro and set the Title to "# Resolved Comments".Â
Within the Report Column macro, add a Report Info macro and set the Key toÂ
page:all comments>collect "inline-status">join with " ">find "Resolved">size