Need JQL Query to fetch the 'Test' issues with links to 'User Story' and Use Story has links to Epic

[Yaadi]

Need JQL Query to fetch the 'Test' issues with links to 'User Story' and Use Story has links to Epic.

We are trying to derive a Dashboard which lists all test counts by Epic. As there is no direct linkage from 'Tests to Epic', want to derive based on 'tests linkage to user Story to Epics' condition.

[Ryan M]

Hey Yadaiah, 

There's not really a way to provide an overview as part of a dashboard out of the box. You could technically use 

issuetype = "User Story" AND "Epic Link" != null 

to grab user stories with epic parents, and add any additional filters, and put the "epic link" field into a standard gadget, but its not really going to organize them well or show % complete, etc, and because the filter has to be run on the children, sorting out closed ones will not show the hole picture - for example, you won't be able to see all the uncompleted children or now what percentage the epic is complete roughly because you can only filter based on the user story itself being closed, not the parent. 

You can utilize Timeline (formerly known as "Roadmaps") to see summarized Epic information on a per project basis, or, if you have Premium/Enterprise cloud you can utilize Advanced Planning to see this information across all projects.

There are also a few options on the marketplace for custom plugins with gadgets that may do what you want if you don't have premium/enterprise, or it HAS to be in a dashboard. Something sort of like this might work https://marketplace.atlassian.com/apps/1223339/simple-status-tracker-for-jira?hosting=cloud&tab=overview

[Yaadi]

Thanks @Ryan M 

Just figured out that Jira 2 dimensional gadget dashboard does not allow to define X axis field from a test issue type and Y axis field from Epic issue type(based on test-userstory-Epic) linkage. It just only works if the Epic Link field exists in same issue type(unless i misunderstood). Here is what i am looking for in view)


Epic Name(exists only in epic) |  Status Type1(exists in Test)   | Status Type2 | Status Type1
..................................................................................................................................................................................

[Ryan M]

Oh sorry I didn't realize at first you're having a hierarchy of 3 different issue types here, is that right? Yeah as far as I'm aware you'll either need to use Timeline/advanced planning instead of a dashboard, or a third party plugin from the marketplace for the dashboard. Reporting functionality in dashboards/gadgets is extremely limited out of box. 

[Yaadi]

@Ryan M Thats correct Ryan! JQL is very limited even with enhanced. Wish it was implemented more like SQL