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
the approver's Atlassian user ids
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 |
|---|---|
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