Filters and sorting

Updated
View as text
Open in Confluence
Open in ChatGPT Open in Claude

Filtering has two modes. Basic builds a query out of chips, which covers most questions. CQL hands you the raw query, which covers the rest.

A filter bar with a keyword box and chips for Contributors, Mention, Parent, Creator, Labels and Macros; the Macros chip is open, listing macro names including Search results, Approval, Calendar, Cloc
Filters you have added sit as chips along the bar, and each one opens its own list of values to match on.

You can start in Basic and switch to CQL to see what it built, which is the fastest way to learn the syntax.

#The filters Search itself provides

Text, Space, Contributors, Created, Updated, Mentions, Favorited by, Ancestor, Parent, Type and Label. Everything else in the filter list comes from another capability.

The filter picker open below the Filters button, with a Built in group listing Text, Contributors, Mentions, Parent, Creator, Labels and Macros, several ticked, and an Approval group listing Creator,
The built-in set comes first, then a group for each capability, so the approval filters only appear where that capability is installed.

#Basic or CQL

Mode

Use it when

Basic

The question fits chips: a space, a date range, a person, a label

CQL

You need a boolean the chips cannot express, or you are copying a query from elsewhere

#Sorting

Any sortable column, ascending or descending. Sorting on a Capable field orders only indexed pages, so a partially indexed site sorts what it knows and omits the rest.

The Sort dropdown open below the Filters, Sort and Columns buttons, listing built-in options Title, Created, Last updated and Author, with Last updated selected and marked descending, then an Approval
The options are grouped the same way as columns, so a capability such as Approval brings its own dates and statuses to order by.

#A few things worth knowing

  • A CQL query with a leading wildcard matches nothing. Confluence does not support it, and it fails quietly.

  • Switching from CQL back to Basic can lose a clause the chips cannot represent.

  • Filter choices are saved onto the saved search, like columns.

Chips first. CQL when they run out.