Display columns for Issue links

Question

Guys

I have a User story and multiple risks linked to the User Story.

I want to run a JQL Query that can give me the below columns when I embed this in Confluence.

Epic Link, User Story Summary, Risk1Summary, Risk1Date; Risk2Summary, Risk2Date

I used the JQL below :

project = XYZ AND issuetype = "User Story" AND issueFunction in hasLinkType("impact")

But when I embed this into Confluence, using the Insert JIRA Macro and selecting tabular view with the columns : Epic Link, Summary, Linked Issues - All I can see is the Linked issue keys.

I want to be able to view the Linked Issues's summaries and their corresponding dates as well.

Option 2 : I am ok with a JIRA board too

Could someone please guide me with this kind of reporting.

Thanks

Sam

Grace · Answer

Was there ever a feature request created for this?  If so could you share the link?

Jordan Lewis_c41xzl · Answer

Can I raise a feature request for this? JIRA pushes you to use Issue Links for things, and yet you can't create reports with a particular Issue Link type as a column. It's very frustrating and hard to make reports that would fit our use case given this limitation.

Shannon S · Answer

Hello Samuel,

Thank you for clarifying that. I've spoken to my colleague in Jira about this, and although it wouldn't be possible to display this using the Jira issues macro, you could use the solution in the below thread:

https://community.atlassian.com/t5/Jira-Software-questions/Get-the-Summary-and-Status-of-linked-issues/qaq-p/1413292#U1417726

You could then try embedding the Google Sheet into an iFrame Macro in the Confluence page.

* In the Google document, click Share on the top-left, and under Get Link, change to Anyone with the link. 
* Now, click File > Publish to the web. This will give you options to display the sheet when viewed from Confluence. Use the link provided within the iFrame macro above.

I used the example from the Embed tab, and I set up my iFrame macro like so:

You don't need to include anything more than the URL at this point, but feel free to adjust this to your liking.

Let me know if you have any questions about that!

Shannon