Examples for CQL expert filter criteria (v 3.3)

Owned by Ronny Winkler
Last updated: Jul 11, 2022
1 min read

The Metadata macros Metadata Overview and Content by Metadata provide an option “Expert filter criteria (CQL)”. This field can be used to insert queries in the Confluence Query Language (CQL). Metadata supports this query language. The next section gives some examples.

 

1) Show all pages where the "location" (a space Metadata field in space with key "EXAMPLE") is either "Stuttgart" or "Dresden":

EXAMPLE.metadatafield.location = "Stuttgart" OR EXAMPLE.metadatafield.location = "Dresden"

2) Show all pages where the "contact person" (a global Metadata field) is Katherine Smith and the location (the same space Metadata field as in the previous example) is "Dresden". The login name of Katherine is ksmith:

global.metadatafield.contactperson = "ksmith" AND EXAMPLE.metadatafield.location = "Dresden"

3) Show all pages of space "Development" (with space key "DEV") which have the metadata set "projects" assigned:

metadataset = "metadataset.projects" AND space = "DEV"

4) Show all pages of space "Development" (with space key "DEV") which have the space metadata set "projects" or “products” assigned: