Reporting app - Pages in state for over 2 weeks
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 workflow-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).
{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
