Confluence Search Sites without specific label

[Benjamin Trablé]

Hi guys,

how can I perform the following search in Confluence Cloud: I want to find all blog posts in a space that have “Release 1.8.3” in the title (e.g. "Revision Billing Assistent - Release 1.8.3") and that do NOT contain a specific label (e.g. “editing_done”).

With Confluence Onpremise, this was possible via the advanced search with JQL search:
title ~ "release 1.8.3" and not label = editing_done

Do you have any ideas?

Thanks and regards

[Guess_ Brandi N_ · Accepted solution]

@Benjamin Trablé 

There's no direct, user accessible CQL search in Confluence.  You'd need to use the API or use an addon.

What you can do is go to the Ask AI and type it in the way you would type CQL and it will parse it out for you pretty well. 



Obviously for me there is nothing because this doesn't exist in my instance, but you should try it in yours

I would recommend using 2 labels, one for finished and one for unfinished to make this easier for you. that way in advanced search instead of that does not include finished label you can just choose the unfinished label from the label dropdown. 

 

[Benjamin Trablé]

All right, thank you.

Yes, working with a todo label will probably be our workaround. You can search for an existing label using the native search. The todo label can be removed when the work is completed.

To do this, we just have to go through the currently affected pages again manually and set the label. Annoying, but probably the quickest way to get ahead.

Thanks for your tips guys

[Benjamin Trablé]

Thank you for your answers. But how do I even get to the CQL search in the cloud?

Simply using a CQL query in the advanced search does not seem to work.
For example, if I search there for “title ~ ”release 1.8.3“ and NOT(label ~ ‘editing_done’)” (with and without the outer quotation marks), this does not work, as pages also come up where, for example, “release” is in the text and not in the title. The same with Ask AI.

[Cyrille Martin]

Hi @Benjamin Trablé 

There are some changes in the Cloud, the label is considered now as a text field. It means that you cannot use the = but the ~ instead.

After some test, if you want to use the NOT my experience is to not leave a blank space.

So you CQL search should be like that :
title ~ "release 1.8.3" and NOT(label ~ "editing_done")

I hope it helps.

Regards,

[Christie Gera @ Appfire]

hey @Benjamin Trablé Welcome!

I've found the Ask AI feature to be remarkably competent as requests like this. Can you try that? This is how I'd frame that query.