Jira Query - Need to have list of Open Epics + Stories under these Epics

[Shajahan A]

Jira Query - Need to have list of Open Epics + Stories under these Epics

[Madhu_RVS]

Hi @Shajahan A 

Welcome to the community !!

For a readymade solution, if you are fine with a mktplace app, you can try out our add-on to visualize and manage your Epic Hierarchy. 

Agile Tools : Epic Tree, Links Tree, Time in Status & Worklogs

Disclaimer : I am part of the team which developed this app

[Hannes Obweger - JXL for Jira]

Hi @Shajahan A

welcome to the community!

Another option would be to go with one of the hierarchy-focused apps from the Atlassian Marketplace. These apps have their own, optimised ways of dealing with Epic/Story relationships and offer more powerful search capabilities.

I can only speak for the app that my team is working on, JXL for Jira - but here, your use case would be trivial to solve:

• Create a sheet that includes any open epics, plus any potential stories below these epics, e.g. with a JQL statement like this: (issueType = "Epic" and statusCategory = "Open") OR issueType = "Story". Don't worry too much about the parent/child relationships; JXL will sort this out for you. 
• In JXL, enable the default hierarchy. That's a one-click operation.

That's it - the resulting view shows your open epics, with their stories below them. This is how this looks in action:

This is actually a pretty simple scenario, and you can model queries that are much more complex. 

It's worth noting that there are several other hierarchy-focused apps, which may or may not offer similar capabilities. You may already know that you can trial any app for free for 1 month (and depending on the size of your site, it may be free forever) - so perhaps try a few and see which solves your use cases best.

Best,

Hannes

[mauricio.groth]

Hi @Shajahan A 

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

You can use this query to find your open epics that have a story or the stories that have an open epic. 

issue in epicsOfChildrenInQuery("type = story") and status = open or issue in childrenOfEpicsInQuery("status = open") and type = story

Check out the documentation for more examples.

If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício