How do I export Tasks with the Sub-Task key(s) included in the same row

Joel Hickson
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 9, 2024

I would like to be able to export all tasks with the subtask keys included in a separate column, separated by commas.  All tasks and subtasks would have identical summary names.  So for example:

If these are the tasks and subtasks:

Issue TypeKeySummary
TaskIAS-10Apples
Sub-taskIAS-11Apples
Sub-taskIAS-12Apples
Sub-taskIAS-13Apples
TaskIAS-14Oranges
Sub-taskIAS-15Oranges
Sub-taskIAS-16Oranges

 

I want it to export like this:

Issue TypeKeySummarySub-Tasks
TaskIAS-10ApplesIAS-11, IAS-12, IAS-13
TaskIAS-14OrangesIAS-15, IAS-16

2 answers

1 vote
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 9, 2024

Hello @Joel Hickson 

Welcome to the Atlassian community.

What "export" functionality are you trying to use? Are you trying to use the export functionality from the View All Issues screen? If so, Jira does not provide a native method to get the data in the format you desire.

You might be able to construct something appropriate with an Automation Rule that would send you the output via email.

You could have a custom field in the Task where you store a comma separated list of the subtask issue keys. You could populate that field with an Automation Rule.

If you are open to getting a third party app, there might be one available that provides the data formatted in that manner.

0 votes
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
April 10, 2024

Hi @Joel Hickson

welcome to the community!

Just to add to Trudy's answer, if you're open to solutions from the Atlassian Marketplace, this would be easy to do using 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 number of so-called smart columns that aren’t natively available, including sub-tasks, number of sub-tasks, and many other related columns.

This is how it looks in action:

sub-tasks-export.gif

As you can see above, you can easily sort and filter by your smart columns, and also use them across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Of course, you can also export your data to Excel or CSV in just one click.

Any questions just let me know,

Best,

Hannes

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events