How to enable advanced CQL lookup in Confluence Automation?

[Dan Ground]

Hi,

We’re building an automation in Confluence Cloud to auto-number SOP pages in our TEC space (format: SOP_001, SOP_002, …).

At the moment, the “Lookup pages” action in Automation only gives us the simplified filters (Author / Created / Last updated). We don’t see an option to enter a CQL query.

From Atlassian docs and examples I’ve found, it looks like some tenants already have access to advanced Lookup with full CQL (e.g. being able to run:

space = TEC AND label = sop AND title ~ "SOP_*" ORDER BY title DESC

That’s exactly what we need to calculate the next number.

Question:

• Is this advanced Lookup (CQL) something that can be enabled by Atlassian support?

• Or is it a staged rollout we just need to wait for?

• Has anyone here successfully requested it to be turned on?

Thanks in advance!
Dan

[Bill Sheboy]

Hi @Dan Ground -- Welcome to the Atlassian Community!

As you observed, the Lookup Pages action cannot do many CQL queries.  Instead, you may use the Send Web Request action to call the Confluence REST API to send the query.

To learn more about that method, please see these sources:

• How to call an endpoint from a rule
  • https://community.atlassian.com/forums/Jira-articles/Automation-for-Jira-Send-web-request-using-Jira-REST-API/ba-p/1443828
• Confluence endpoint for the CQL query
  • https://developer.atlassian.com/cloud/confluence/rest/v1/api-group-search/#api-wiki-rest-api-search-get
• CQL reference
  • https://developer.atlassian.com/cloud/confluence/advanced-searching-using-cql/

Kind regards,
Bill