List all Comala Document Management workflow statuses

Scenario

This recipe creates a report that compiles and displays the Appfire Comala Document Management applied workflow status for each page from a space. This is rendered in a table on a page.

It includes

pages from the space
the workflow status for each page
an approver's Atlassian user-id

The scenario uses an applied workflow with the following workflow states

Review
Rejected
Approved

The Comala Document Management Cloud app includes the Basic Approval Workflow with these three workflow states

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 Cloud Comala Document Management Cloud

Apps	Reporting for Confluence Cloud Comala Document Management 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 approver's name cannot be returned as a value