How to find issues linked to a specific Confluence page using JQL?
Platform Notice: Cloud - This article applies to Atlassian products on the cloud platform.
Summary
This article explains in simple words how to find issues that have the Confluence pages linked to them using JQL. JQL stands for Jira Query Language and is the most powerful and flexible way to search for your issues in Jira. In any Cloud site, you could go to the option on top Filters → View all issues to find issues using JQL. While there are multiple functions, keywords, and operators that can be used in the JQL to search for issues, there is no way to search for issues if they have a Confluence page linked to them.
Environment
This article is applicable to issues in the Jira Service Management Cloud.
Cause
The main cause of this problem is that this feature does not exist in JSM as of now. For this reason, we're tracking a feature request here:
We would really appreciate it if you and your team could vote for this issue by clicking the Vote for this issue link on the suggestion. To also receive updates related to this suggestion, you can add yourself as a watcher by clicking the Start watching this issue link on the same page.
Workaround
While this is not a permanent solution, it can be used as a workaround until the aforementioned feature is implemented in the product. Please follow the steps mentioned below in order to list the issues that have the Confluence page linked to them:
- Navigate to one of the Jira issues which are linked to that specific Confluence page (as an example it is https://<yoursitename>.atlassian.net/browse/<issuekey>)
Execute the endpoint
https://<yoursitename>.atlassian.net/rest/api/3/issue/<issuekey>/remotelink
in the browser.
- Use an extension like JSONVue, JSON Formatter or JSON Viewer in Google Chrome to properly view the output.
- Copy the value of globalId from the result (in this example it is appId=7efaf2f9-52ef-33e3-88a1-95fec4b5e93a&pageId=39256065)
Now, go to Filters → View all issues on your cloud site and follow the steps:
- Switch to JQL and type the following JQL query:
issue in (issuesWithRemoteLinksByGlobalId("appId=7efaf2f9-52ef-33e3-88a1-95fec4b5e93a&pageId=39256065"))
The result will be displayed as
Important!
The described method will not work for Web Links. Make sure you are using "Confluence content" link type (app link):
Contact Atlassian support if you have any questions.