Show Status of linked issue using Jira Issue Macro

[AJ]

I have built a dashboard using the Jira Issue Macro. I have it all working but one item related to "linked issues" and "status" 

Here is our scenario:

1. Jira issues are created on one board. 
2. Based on the issue type/need, it gets moved to another project board based on the team's capabilities. 
3. When the requestor of the ticket is trying to view the status of their ticket, currently they can't see it without going into the specific ticket. 
4. I want to show the "status" of that ticket ie: is it in a sprint, done, etc on the main dashboard. 

Attached is a screenshot of what I have built so far. It all works, except for the "status" of the "linked issue." Do you know what I need to add into the query parameter to get this? 

If it technically cant be done due to Jira Cloud limitations. What have others done as a workaround except for just "clicking" into each and every ticket. 

[Emily Lukasik]

@AJ - Did you ever determine a workaround for this?   I have the exact same scenario, and would love to create the same view

[Rachel Wright]

Hi @aj, I don't think you can reach into the linked issue, to grab the status, with JQL.  What you could do however, is modify your query to include the linked issues.

So for the example above, your query would be:  

issue in linkedIssues(APPX-351)

You can also specify the link type, if that's of interest:

issue in linkedIssues(APPX-351, "Relates To")

Obviously, this method doesn't scale well.  You might be better off just creating a query that returns all the issues you want (not just linked issues.)

Otherwise, you could use the Jira REST API to create a custom solution.  And Server users (only, sorry) could access the data from the database.  

Hope this helps a little,

Rachel Wright
Author, Jira Strategy Admin Workbook