JQL Query for Project-Epic_Stories

[Brian Bajuscak]

I am looking for help pulling this data from Jira.

I am looking to gather a listing of Epics associated with a Project, and the stories associated with each Epic for that project.

I am able to pull all stories and epics for a project in one big, out of order listing using

"issuekey in portfolioChildIssuesOf(PROJ-XXXX)"

, but I'd like to extract the data such that the stories are listed with each associated epic.

Ex.

Project

Epic

Story

Story

Epic

Story

Epic

Story 

Story

Story

[Hannes Obweger - JXL for Jira]

Hi @Brian Bajuscak

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 range of advanced features, including the ability to show your issues in their epic/base-task/sub-task hierarchy in just one click - like so:

Every JXL sheet is powered by a JQL statement or saved filter, so you have full control over which issues you want to include. You don't really have to worry about the parent/child relationships, as this is sorted out by JXL for you. You can also further fine-tune your list of issues via JXL's various in-app search and filtering capabilities.

Once you've narrowed down your list of issues, you can work on your issues directly in JXL, trigger various operations in Jira, or export your issues with just one click.

Any questions just let me know,

Best,

Hannes

[Danut M _StonikByte_]

Hi @Brian Bajuscak,

Unfortunately, you can't do this at the JQL level.

But what do you want to achieve? Why do you need that JQL?

I ask because, for example, if you want to have epics along with their stories displayed on a dashboard, it might be better to look for a gadget that can do this, instead of JQL. So please clarify.

If displaying the epics along with their stories (and eventually the sub-tasks) on a dashboard is a good solution for you, then  you could search for a plugin that offers a gadget that is able to do this. 

If you consider using a plugin, our Great Gadgets app offers a Work Breakdown Structure (WBS) gadget that displays the issues from a filter or JQL by their hierarchy (Epic > Story > Sub-task). All you have to do is to configure the gadget with a filter or JQL that returns the issues to be grouped and it does the grouping for you. It supports also portfolio initiatives (extra levels added on top of Epic). 

For your case, will be enough to configure the gadget to use a filter like this:

project IN (A, B, C) AND issueType in (Epic, Story)

Danut.

[Kris Dewachter]

HI @Brian Bajuscak ,

Welcome to the Atlassian Community.

Unfortunately, you can not group items like that with JQL.

Why do you want it listed like that? Maybe other options are available.

Best regards,

Kris

[Brian Bajuscak]

Hi @kris ,

   Thanks for the feedback. I am hoping to produce a listing in this format because it would allow me to verify stories are nested under the correct epic. All other methods I have come across only produce a large listing of all epics and stories within a specified project, but fail to provide the hierarchy of stories and the associated epics they fall under. Hope this clarifies the need.

Thank you

[Kris Dewachter]

Hi @Brian Bajuscak ,

I'm a bit confused. You posted this question in the "Jira Service Management" group. Are you using "epics" and "stories" in "Jira Service Management" or "Jira Software" ?

If it's Jira Software, you could use the "Timeline view" of your Jira project to visualize the structure.

And if you even have "Jira Software Premium", you could also the "Plans" functionality.

Best regards,

Kris