As a regular user, how do I get access to CQL?

[Abhay Patil]

I am a regular licensed user of Confluence. I do not see any option to access Confluence Query Language (CQL). Does one need to buy "Scriptrunner for Confluence" license to gain access to CQL? What is the best and right way for user to gain access to CQL - to use it as conveniently as one uses JQL for JIRA?

[Aron Gombas _Midori_]

@Abhay Patil As you noted, CQL is not made that prominent in Confluence as JQL is in Jira. I asked it several times why not, but haven't heard any acceptable answer. I would find CQL a super-useful tool to run structured queries against Confluence content.

Anyway, apps can help with it until Atlassian offers an out-of-the-box solution. See this page that mentions two apps that offer macros powered by CQL, ad-hoc CQL searches or  even ready-made status reports.

[Tomislav Tobijas]

Hey @Abhay Patil ,

Confluence doesn't have 'CQL search bar/option' (something similar to Jira JQL search). CQLs are mostly used in automation rules (see examples) or within some third-party apps (like ScriptRunner).

I'd say that main question is what's the requirement here 👀 Like, why do you need to use CQL instead of standard, user-faced filters.

Here's some additional documentation about this: Advanced searching using CQL

There's also a feature request about improvements in that area: AI-584: Improve Advanced Search in Confluence UI with CQL 

Cheers,
Tobi

[Abhay Patil]

Thanks @Tomislav Tobijas
We just want to inspect our Confluence repository with queries, e,g. how many documents are in status "ready for review", which documents got changed since some date, which are the documents owned by a certain user and so on. So looking for a way to execute such query from UI.