Searching for pages with a set of labels 'ANDed' together, not 'ORed'?

Question

Using the search function on a space, is there a way for the labels field to search for pages with all the labels listed 'ANDed' together and not 'ORed'?

For example: I want to return pages that have both the label 'chocolate' AND 'cake' as labels on them, not all of the pages that have 'chocolate' OR 'cake' as labels.

How can I do this?

dhaskell · Answer

I gave this a try and I still get all sorts of stuff that has either of the labels, or content that matches the labels. I must be doing something wrong.

Lukas Ortner · Answer

Hello,

you can use CQL (Confluence Query Language) and give the following search:

label = chocolate and label = cake and space = SPACEKEY

Cheers, Lukas