The CQL Filter parameter of the Document States Report macro now accepts Confluence CQL format functions, keywords, and can include OR and comparison operators (from v.6.16.7+).
prior to v6.16.7 CQL filter in report macros must be in the form
Using CQL filters in the document-states-report macro
For example, the following pages all have the label hr in a space.
But our added CQL filter will cause the report to display only the page(s) that have both the label hr and were created by the user matilde.
You can use functions in the CQL, for example, the following includes an OR function.
This will display content that has either
- the label hr
- has been created by the user matilde
Filters are additive, if there are any logical clashes then no results will be returned
The CQL field
awphasworkflow=true is always applied so content without a workflow will not be included in the report.
Other compatible CQL filters include
Beware that errors may occur when the specified CQL filter and the macro filter options overlap. Also note that CQL itself has limitations that mean that certain field types only support certain operators
CQL filter examples
There is no content with the specified labels
Comala Document Management documentation
- Confluence Search Syntax
- Advanced Searching Using CQL
- CQL Field Reference
- CQL Function Reference
- CQL Keywords Reference
- CQL Operators Reference
- Performing Text Searches with CQL