Where to use/write CQL in the Confluence UI to get a list of pages?

[JG Meillaud _]

Hello,

In short: I'm looking of the equivalent of https://COMPANY.atlassian.net/issues/?jql=QUERY

I'd like to search for pages using CQL and get a list of pages, what is the quickest way to do this?

Ideally I'd like to do this within the normal Confluence UI.

Also, is there a list of places where we can use CQL, for example I think you can use it within automations or through API, where else?

Thanks,
JG

[Peter Quick · Accepted solution]

Howdy,

There is a UI that inadvertently lets you test CQL.

Using Confluence Automation, build a rule, add a Branch rule / related entities thingie.

This accepts CQL and has a Validate query button under your query line.

Click the Valid query...  link.

The result set opens in a separate tab in the Search interface.

Clunky? Yes, but it gets you out of a jam.

Cheers,

PeteQ

[Aron Gombas _Midori_]

It is a creative approach, I must admit. Not the most intuitive, but does the job without an additional app.

[JG Meillaud _]

Thanks a lot @Peter Quick 

This also brings you to https://COMPANY.atlassian.net/wiki/search?cql=QUERY which seems to work!

[Aron Gombas _Midori_ · Accepted solution]

There is no built-in UI for this, but there is an app to fill the gap: https://marketplace.atlassian.com/apps/1213090/cql-search?hosting=cloud&tab=overview

It works great and it used to be free (now paid).

[JG Meillaud _]

Thanks Aron,

So sad, and hard to believe that the product team did not think this as a must have feature...

[Aron Gombas _Midori_]

@JG Meillaud _ I 100% agree. This is unbelievable. I hope they will release this soon.

[Lucas Modzelewski _Lumo_]

check: https://COMPANT.atlassian.net/wiki/search

[JG Meillaud _]

Thanks Lukasz, however this does not accept CQL on my site.

[Barbara Szczesniak]

@JG Meillaud _ The following may help you:

• https://developer.atlassian.com/cloud/confluence/advanced-searching-using-cql/ 
• https://community.atlassian.com/t5/Confluence-articles/Useful-CQL-statements-to-search-what-you-need-in-Confluence/ba-p/1769849 
• Search for pages, posts, and other items | Confluence Cloud | Atlassian Support
• https://support.atlassian.com/confluence-cloud/docs/confluence-search-syntax/ 

[JG Meillaud _]

Thanks Barbara, however still no CQL input feature in the UI 😿