Scenario

This recipe creates a report that compiles and displays all Comalatech Document Management(CDM) statuses from a space in a form of a table on a page. It includes pages from the space, the CDM workflow statuses - Review, Rejected, Approved, and as well as the approvers Atlassian IDs.

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

{
  "cql": "cw_state = 'Review' or cw_state = 'Approved' or cw_state = 'Rejected'",
  "tab": 0,
  "expansions": "content.metadata,content.metadata.properties,content.metadata.properties.cwc_page_admin,content.metadata.properties.cw_status",
  "filters": [],
  "reportInfos": [
    {
      "id": "9687f0ca-7778-4dc0-8733-828cc01520f5",
      "type": "link",
      "title": "Page",
      "value": "content.id",
      "attr": {
        "link": "url",
        "placeholder": "content.title"
      },
      "template": ""
    },
    {
      "id": "ff65bba3-440a-49a3-94a3-7a0e28bda5f1",
      "type": "basic",
      "title": "Current State",
      "value": "content.id",
      "attr": {
        "value": "content.metadata.properties.cw-status.value.state.name"
      },
      "template": ""
    },
    {
      "id": "25c82240-624f-403f-a705-4e9db02a65e1",
      "type": "basic",
      "title": "Approver Atlassian IDs",
      "value": "content.id",
      "attr": {
        "value": "content.metadata.properties.cw-status.value.state.approvers"
      },
      "template": ""
    }
  ]
}

Result

Recipe

Apps


Reporting for Confluence CloudComala Document Management


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 approver's name cannot be returned as a value - may be implemented in the future.