| Info |
|---|
From Comala Document Management v6.16.6, you can use CQL format filters in the Comala Document Management document states report macro to create a report like this. See CQL filter - reporting pages that have been approved or expired in a time period for an example. |
Overview
This example requires the Appfire Reporting for Confluence app.
Example
The following report uses the
...
...
reporter macro to list all the pages in the AWP space
...
that have a current workflow state of For Review.
It then filters those results, using the date-filter, to only include pages that have been in the same state for more than two weeks (from the current date).
| Code Block | ||
|---|---|---|
| ||
{report-table}
{workflow-reporter:spaces=AWP|states=For Review}
{date-filter:workflow:state > date|maxValue=-2w}
{workflow-reporter}
{report-column:title=Page}{report-info:content:title|link=true}{report-column}
{report-column:title=Last published}{report-info:states > Published > date > dd/MMM/yyyy}{report-column}
{report-column:title=Send for review on}{report-info:workflow:state > date > dd/MMM/yyyy}{report-column}
{report-column:title=Last Updated}{report-info:content:modification date > dd/MMM/yyyy}{report-column}
{report-column:title=Last Updated By}{report-info:content:modifier > full name|link=true}{report-column}
{report-column:title=Tasks?}{report-info:workflow:tasks > 1 > name}{report-column}
{report-column:title=Labels}{report-info:labels}{report-column}
{report-empty}
There are no pending pages
{report-empty}
{report-table} |
Output
...
