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

Question

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.

Yaadi · Answer

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

Ryan M · Answer

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 · Answer

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
..................................................................................................................................................................................