JQL | Epics and associated user story detail

[afernandezdecastro]

Hello, I am looking for a query, which will help me to check the "Epics" and their associated User Stories with the detail of each User Story.

result of my query: image (query1.jpg)

what i want to get with a query: image (query2.jpg)

thanks

Ennio

[Kevin Dalton · Accepted solution]

You could try

"Epic Name" = "Bob's Epic" or "Epic Link" = "Bob's Epic"

Should return all issues under the Epic and the Epic itself

[Benjamin · Accepted solution]

@afernandezdecastro ,

You can do something like this:

parentEpic in (EpicID)

This will result in the Epic and the issues that are Epic linked.

It won't show up exactly as pictured but you can add and remove columns as needed to get it to the desired result.

-Ben

[afernandezdecastro]

Hi Benjamin,

I get the same as the first image when I run it. :(

[Benjamin]

Hi @afernandezdecastro ,

It should show up. How are the stories link? Are they using the Epic link or issue linking?

-Ben

[Trudy Claspill]

@afernandezdecastro 

Are your issues in a Team Managed project or a Company Managed project?

The parentEpic function works only for issues in Company Managed projects.