/
List open and resolved comments from each page in a space

List open and resolved comments from each page in a space

Scenario

With this recipe, you can build a report that lists the number of open and resolved comments on each page in a space.

Result

Recipe

Apps

Reporting for Confluence 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

Macro structure

You can recreate the example in the editor view:

Steps

  1. Create a Report Table macro.

  2. Within the Report Table macro, create a Content Reporter macro with Types: page. 

  3. Within the Content Reporter macro, create an And Filter macro.

  4. Within the And Filter macro, create a Text Filter with the following parameters:

    • Key: page:all comments>collect "inline-status"

    • Required: selected

  5. Within the And Filter macro, create a second Text Filter with the following parameters:

    • Key: page:all comments>collect "inline-status"

    • Exclude: .*Dangling.*

    • Required: selected

  6. Within the Report Table macro, under the Content Reporter macro, create a Report Column macro with Title: title/page.

  7. Within the title/page Report Column macro, add a Report Info macro with the following parameters:

    • Key: page:title

    • Link to Item: selected

  8. Within the Report Table macro, under the title/page Report Column macro, create another Report Column macro with Title: # Open Comments.

  9. Within the # Open Comments Report Column macro, add a Report Info macro with Key: page:all comments>collect "inline-status">join with " ">find "Open">size

  10. Within the Report Table macro, under the # Open Comments Report Column macro, create another Report Column macro with Title: # Resolved Comments.

  11. Within the # Resolved Comments Report Column macro, add a Report Info macro with Key: page:all comments>collect "inline-status">join with " ">find "Resolved">size.