A keyword in CQL is a word or phrase that:
See the detailed examples for each keyword next.
Used to combine multiple clauses, allowing you to refine your search.
Note: to control the order in which clauses are executed, you can use parentheses.
Find all blogposts with the label "performance".
label = "performance" and type = "blogpost"
Find all pages created by jsmith in the DEV space.
type = page and creator = jsmith and space = DEV
Find all content that mentions jsmith but was not created by jsmith.
mention = jsmith and creator != jsmith
Used to combine multiple clauses, allowing you to expand your search.
Note: to control the order in which clauses are executed, you can use parentheses. Also see IN, which can be a more convenient way to search for multiple values of a field.
Find all content in the IDEAS space or with the label idea.
space = IDEAS or label = idea
Find all content last modified before the start of the year or with the label .
lastModified < startOfYear() or label = needs_review
Used to negate individual clauses or a complex CQL query (that is a query made up of more than one clause) using parentheses, allowing you to refine your search.
Find all pages with the "cql" label that aren't in the dev space.
label = cql and not space = dev
Used to specify the fields by whose values the search results will be sorted.
By default, the field's own sorting order will be used. You can override this by specifying ascending order ("") or descending order ("").
Not all fields support ordering. Generally, ordering is not supported where a piece of content can have multiple values for a field, for instance ordering is not supported on labels.
Find content in the DEV space ordered by creation date.
space = DEV order by created
Find content in the DEV space ordered by creation date with the newest first, then title.
space = DEV order by created desc, title
Find pages created by jsmith ordered by created, then title
creator = jsmith order by created, title asc