Query A list of Epics and list of all relatable stories with their child issues.

Question

Is there a way to query A list of Epics and list of all relatable stories with their child issues into one exportable file?

I created a query/filter that limits my list of Epics, then a separate file for the stories and a separate file for the child issues, but I was hoping it could be done in one step.  Here is my queries so far:

project = t5064 AND issuekey in portfolioChildIssuesOf(T5064-164) ORDER BY cf[10158] ASC

This returns a list of stories but not the list of related child issues.  There must be a simpler way to accomplish a all inclusive list Epics that match my criteria and all their related stories, & Child issues.

Any assistances is greatly appreciate.

Karen Schaefer

Hannes Obweger - JXL for Jira · Answer

Hi @Karen F. Schaefer

as Stephen suggested, this is a bit trickier than one would think and, depending on your exact use case, may require some additional tooling.

If you're open to solutions from the Atlassian Marketplace, another direction would be to use 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 of searching through and exporting issue hierarchies.

As an example, my team and I work on an app in which your use case might be trivial to solve: 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 the ability to enable Jira's default issue hierarchy (i.e., epic/story/sub-task) in just one click. You can also easily export the resulting issue list to XSLX (i.e., Excel or Google Sheets) or CSV format.

This is how it looks in action:

To view one particular epic with all its children, you can use JXL's rich in-sheet filtering capabilities to narrow down your list. The default hierarchy as shown above can also be combined with JXL's other advanced features, such as configurable issue hierarchies (e.g., based on issue links), issue grouping by an issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes

Danut M _StonikByte_ · Answer

Hi @Karen F. Schaefer,

Try a JQL like this:

parentEpic IN (DEMO-1, DEMO-2)

This works if the parent elements are epics and returns the epics themselves along with their stories and tasks and their sub-tasks.

If you have Initiatives (created with Advanced Roadmaps) on top of epics it might not work. Instead, you could try the Work Break-Down Chart gadget offered by our Great Gadgets app.

This gadget displays the issues from a filter in a tree structure according to their hierarchy: Epic > Tasks, Stories > Sub-Tasks along with their status, giving you a quick overview of the work's content and progress. If you have initiatives on top of epics, they will be also displayed: Initiative Level 1... > Initiaitve Level 2... > Epic > Tasks, Stories > Sub-Tasks

All you have to do is to configure this gadget to use a (larger) filter that includes these issues (by project, for example) and it will do the grouping for you.

This app offers many other gadgets for Scrum, Kanban, SAFe, Service Desk projects. To make a better idea, have a look over the articles from our blog.

I hope this helps.

Thank you,

Danut.

Ste Wright · Answer

Hi @Karen F. Schaefer

Are the child issues sub-tasks? I used the JQL function above and it shows me all the story-level and sub-task-level issues below an Epic.

This is what is possible in native Jira.

Beyond this, when you want to do sub-querying (eg. give me all the Stories of any Epic which has a specific label), you'll need an App which extends JQL functionality.

Examples of these Apps include...

* JQL Search Extensions
* Enhanced Search (also part of Scriptrunner)
* ...or another App from the Marketplace

Ste