How do i get list of all user stories (all status) for a EPIC with specific status

[Pravin Kumar]

We want to list out all user stories (all statuses) for a EPIC.

EPIC has specific workflow status, So based on the EPIC status we need to display all stories.

At high level  -  List all stories where Epic status= Accepted 

[mauricio.groth]

Hi @Pravin Kumar

I’m Maurício, a support engineer at Digital Toucan and I’m here to help you.

Unfortunately, using JQL of Jira, you’ll not be able to do it.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all your stories that are children of epics whose status is “Accepted”

issue in childrenOfEpicsInQuery("status = Accepted") and type = Story

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!
Best regards,
Maurício

[Hannes Obweger - JXL for Jira]

Hi @Pravin Kumar

unfortunately, "plain" Jira isn't too great with searching across issue hierarchies, so to the best of my knowledge, you'll need extra tooling to solve your use case. A few directions forward:

• If you have Jira Premium, this should be possible in Advanced Roadmaps. If you create a plan that includes the relevant epics (with status = "Accepted"), as well as any potential stories, AR should show the stories under these relevant epics; any stories that don't belong to the relevant epics should be in some Other level X issues "bucket" that you can ignore.   
• You may be able to "propagate" the information from the epic down to the child stories using Jira Automation, and then filter by the respective field on the stories.
• There's different apps from the Atlassian Marketplace that can help with that. First, there's a number of apps that extend JQL by additional functions, including hierarchy-related functions. I've used JQL Search Extensions a few times and it works great.
• Alternatively, you could try one of the more hierarchy-focused apps from the Marketplace. These apps typically have their own ways of figuring out parent/child relationships between issues, and provide more powerful ways to define and navigate through issue hierarchies. I myself work on such an app, in which your use case would be easy to solve; I'll provide more details below.

Hope this helps,

Best,

Hannes

[Hannes Obweger - JXL for Jira]

Just to expand on the last point, this is how this would look in the app that my team is working on, JXL for Jira; TLDR: You'd create a sheet with your relevant issues, enable the default hierarchy (that's just one click), and then use JXL's various filtering capabilities to narrow down your list of issues:

Once you have your list of issues, you can work on these directly in JXL (much like you'd do in e.g. Excel or Google Sheets), trigger various operations in Jira, or export them for further processing.

As said above, there may be other apps that help with this, too. You may already know that you can trial any app for free for 1 month, and depending on the size of your size, it may be free forever. So if an app is an option for your, perhaps try a few and see which works best for you.

Any questions just let me know!

[Madhu_RVS]

HI @Pravin Kumar 

You can use Advanced Roadmaps if you are on Jira premium to achieve this functionality.

Alternatively, you can try out our app, which give you multiple filter options for your parent issue which can be Epic. Also there is a feature to filter out child issues to based on their status, issue type or even use your own custom JQL.

Issue Hierarchy Reports 

Disclaimer : I work for the vendor who built this app