Get all parent epics for for a set of stories

[Craig Gall]

For a given JQuery that returns a list of stories I want to only list the parent epic that contains them. 

For example i have epics 1 through 10. In each epic i have say 100 stories.

If i query the stories that fall in my current sprint and that returns 50 stories.

I want to only return the parent epic that those 50 stories are related to.

I can see plenty of queries that work the other way around e.g. return the stories for a set of epics. 

[Tomislav Tobijas _Koios_]

Hmm, I'm not sure if you'll be able to get that with native JQL queries and functions @Craig Gall .

You could take a look at this reply from Trudy. For getting parents, you would usually use parent or parentEpic functions. However, these require specific keys for parents and I'm guessing you don't want that.

Also, as you can't (yet) use nesting in JQL functions - see JRACLOUD-21936: Allow nested JQL function calls , you cannot use queries like 🙁

parentEpic IN (Sprint IN openSprints()) and issuetype = Epic

Hopefully someone has found some workaround for this.

Apart from that, there are enhanced search apps/functionalities from Marketplace such as ScriptRunner Enhanced Search which could probably get you what you need.

Cheers,
Tobi

[Pasam Venkateshwarrao]

Hi @Craig Gall 

yes you can try using the below query

issue in ( linkedIssues("Epic-XYZ") AND issuetype=story