How to Embed Linked Jira Issues into Confluence page

[Kyle Hikalea]

I'm attempting to embed a list of Jira issues that are related to a Confluence article but can't seem to find the correct part.

Natively, the related issues are linked at the top of the Confluence article and can be accessed using this button:

However, when I try and add this issue list directly to the body of the page, I can't seem to find the JQL expression that would accomplish this:

[Brant Schroeder · Accepted solution]

@Kyle Hikalea Welcome to the Atlassian community

When using the Jira Issue Macro this will place a list of issues on the Confluence page by embedding a JQL filter or saved filter results on a page.  More information here: https://support.atlassian.com/confluence-cloud/docs/insert-the-jira-issues-macro/ 

If you are trying to link specific issues to a Confluence page you can do it in Jira on the issue by selecting the little down arrow by link issue and selecting Link Confluence page. 

Additional Helpful information - https://www.atlassian.com/blog/confluence/link-jira-issues-to-confluence-pages-automatically 

[Kyle Hikalea]

Thanks for your reply, @Brant Schroeder -

I am able to insert the Jira Issue Macro, but it displays all issues, not just those linked to the article I'm working on. From the Jira side, I have no problem linking an issue to a specific page. But I cannot figure out how to create a JQL filter to apply to the Jira Issue Macro to ensure that it only displays issues that have been linked to a specific page.

[Brant Schroeder]

@Kyle Hikalea If you have an app like script runner you can create a JQL query that will display only the issues associated with that page.  Otherwise, you would have to past the link of each issue on the page.  

You can vote for this feature request as well https://jira.atlassian.com/browse/CONFCLOUD-74355 

[Kyle Hikalea]

This page solved it for me without using an additional app:
Jira query on mention in Confluence page (atlassian.com)

Tldr the JQL is:

issue in (issuesWithRemoteLinksByGlobalId('appId=<APP_ID>&pageId=<PAGE_ID>'))

[Brant Schroeder]

@Kyle Hikalea Great, thanks for providing the solution so others have it.