Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Scenario

This recipe creates a report that compiles and displays all Comalatech Document Management(CDM) statuses the Appfire Comala Document Management applied workflow status for each page from a space in a form of . 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:

Code Block
{
  "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

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

  • enable Get all results below the search box if you need to view more results

...

Caveats

  • The the approver's name cannot be returned as a value - may be implemented in the future.

...