Get all parent epics for for a set of stories

Question

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.

Hannes Obweger - JXL for Jira · Answer

Hi @Craig Gall

welcome to the community!

If you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on: JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

With these, you can build a view like e.g. this in just a couple of clicks:

This is really just one of a virtually endless number of possible views and reports; you can also view and group by any other issue fields, configure different sum-up styles, etc. etc.

Any questions just let me know,

Best,

Hannes

Dmitry Astapkovich _Colined_ · Answer

Hi @Craig Gall ,

If you are ok to use third party apps, you can try Pivot Report we develop:

You can check this demo report by yourself or schedule a quick call with me to go over the app in details.

Tomislav Tobijas · Answer

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