CQL for getting confluence pages based on linked JIRA tickets

[alexmears]

Confluence allows you to identify how many JIRA issues have linked to a Confluence page:

1. Is there a CQL that can pull all confluence pages with JIRA links?
2. Is there a CQL that can pull all confluence pages with JIRA links of a particular status e.g. "Needs Review"?

[Sattesh M]

Hello Alex,

I don't think you can look for pages with Jira links with a particular status using CQL, but you can look for all pages that have Jira links.
Since any jira link becomes a "jira" macro in a Confluence page, just look for the macro "jira", and you should get a list of page with Jira issues in them.

• (ConfluenceBaseURL)/rest/api/content/search?cql=macro%20=%20jira

Hope that helps!

Cheers,
Sattesh