...
These are two examples of using a CQL filter of the document states report macro to create a dynamic report
report content state changes to a specific state in a the 2 week period prior to before the current day
report on content set to expire in the next 4 weeks
The CQL Filter parameter now accepts Confluence CQL format functions , and keywords , and can include OR and comparison operators. Simply add Add the CQL format filter to the CQL filter dialogue box in the document states report macroeditor.
Pages published in the last 2 weeks
In this simple example, we have one workflow applied in the space. The workflow has a final state , of Approved.
The report can be filtered to a specific destination state for a workflow approval. In our example, this is the workflow workflow’s final state, Approved.
We can add the following CQL to the CQL Filter dialogue box in the document states report macro editor
...
This CQL filter will list in the report all the state changes that have occurred in the report in the last two weeks.
In addition,
...
The report displays content transitioned to the Approved state (workflow final state) in the last 2 weeks prior to before the current day.
This report example may include content that transitioned to the Approved state in the period set by the CQL filter but is currently in a different workflow state.
The report columns have been configured to include the content version on the transition to the final state, Approved.
...
A rolling report can be generated to the end of the current period using a CQL function reference, for example example,
stateexpiry<endOfMonth()
Or from the beginning of a period using, for example, since the beginning of the month
...
You can set periods for these CQL functions, for example, in the 7 days prior to before the current day
stateexpiry> startOfDay("-7d")
The CQL filter option is just one of the filter options available in the document states report macro.
Related links
Comala Document Management CQL filter examples
| Filter by label (Content by label) | ||||||||
|---|---|---|---|---|---|---|---|---|
|
Related documentation
...