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:
| 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 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.
Copyright © 2023
• Powered by Scroll Viewport & Atlassian Confluence