nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Show parent, sub tasks and child issues on report

Natalie Keane

I need to show either on a report or in an exported Excel file the subtasks and child issues shown in the timelines for each project.

I need to do the above on a weekly basis. Please could you advise how to do this?

The purpose is to show the status for both subtasks and child issues.

Currently when I do export (all fields), it doesn't include the child issues. I'm happy to use a free app, but can't pay for one and need to pull this report weekly.

Please note I'm on the free Jira plan.

Thank you in advance for your help.

Accepted answers

Jack Brickey

Hi @Natalie Keane , to create a JQL query that provides the results you desire we must understand the common characteristics that define the desired results. Examples:

return all open stories, tasks, sub tasks for a project ABC == project = ABC AND type in (story, task, sub-task) AND resolution is empty
return all open stories, tasks, sub tasks for a project ABC == project that include "my-label" as a label = ABC AND type in (story, task, sub-task) AND labels = my-label AND resolution is empty

so could you define the issues you wish to capture by your query?

All comments

Jack Brickey

Hi @Natalie Keane , to create a JQL query that provides the results you desire we must understand the common characteristics that define the desired results. Examples:

return all open stories, tasks, sub tasks for a project ABC == project = ABC AND type in (story, task, sub-task) AND resolution is empty
return all open stories, tasks, sub tasks for a project ABC == project that include "my-label" as a label = ABC AND type in (story, task, sub-task) AND labels = my-label AND resolution is empty

so could you define the issues you wish to capture by your query?

Natalie Keane

I'm really sorry. I don't understand what you mean? I'm new to Jira and just want to be able to export parent, sub tasks and child issues in either Excel or a report. Please would you mind explaining in really simple terms? Thanks.

Hannes Obweger - JXL for Jira

Hi @Natalie Keane

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 hierarchy in just one click.

This is how it looks in action:

Every JXL sheet is powered by a JQL statement or saved filter, meaning that you have full control over which issues you want to pull in. You don't really have to worry about parent/child relationships, as JXL is sorting this out for you. You can also further limit the visible issues through JXL's rich filtering capabilities.

Does this look like it could be useful to you?

Best,

Hannes

Natalie Keane

Thank you for the suggestion. I can only use the free apps though. Is this free? Is there really no way to show the child issues in excel or a report using the free version of Jira?

Hannes Obweger - JXL for Jira

Hi @Natalie Keane,

JXL is free for Jira sites with up to 10 users. Since you're on the free Jira plan, I'd assume that this would be the case for you!

Best,

Hannes

Natalie Keane

Great. Yes if it's definitely free. How do I get the free version? Is it a plugin from Jira or a separate download?

Rahul_RVS

Hi @Natalie Keane

Welcome to the community !!

If you would be interested in a mktplace app, do take a look at

Issue Hierarchy

The app shows your issue hierarchy in a tree view and the same view can be exported to a CSV file. The app has multiple other features which are very useful in project tracking and management and is free for upto 10 users.

(Disclaimer: I work for RVS, the vendor for this app)

Epic Hierarchy - CSV export - animation.gif

Natalie Keane

Thank you. How do I link this app to Jira? How long is it free for? Does it export the information to excel?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud