Display columns for Issue links

[Samuel Avinash]

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

[Shannon S]

Hi Sam,

Happy to help you with this!

When inserting the Jira Issues macro, you can choose which columns display. Summary is one of these fields that will automatically display. In general, you can display nearly all fields, with the exception of certain custom fields.

Could you help me to understand what kind of fields these are that you need to show, and if they don't appear in the list of columns to display when editing your Jira Issues macro?

Take care,

Shannon

[Samuel Avinash]

Thanks for trying to answer Shannon. Let me explain this again.

Issue 1 Type = User Story

Issue 1 has Summary and  Description fields

Issue 2 Type = Risk

Issue 2 has Summary and Impact Date fields

Issue 2 is set up as a link to Issue 1(Issue 2  impacts Issue 1)

Issue 3 also same as Issue 2(another issue that impacts Issue 1)

Now am able to run a JQL Query that displays the Issue 1 and it's linked issues(Issue 2, Issue 3...)

But I am only able to select/View

Issue 1 Summary.

I want to view Issue 1 Summary, Issue 2 Summary Issue 3 Summary(likewise any of the other fields of issue 1, 2 and 3

[Shannon S]

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.

1. In the Google document, click Share on the top-left, and under Get Link, change to Anyone with the link. 
2. 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

[Jordan Lewis]

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.

[Grace]

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