Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

I need to Export Epic (pcf-522) with all the issues and subtasks

John Eckhoff September 17, 2019

I believe I need an advanced search?  JQL  Need all stories and subtasks in particular epic (pcf-522) tasks /subtasks are PCF-523 thru Pcf-631.

2 answers

1 vote
Jack Brickey
Community Champion
September 17, 2019

Without an addon it is challenging at best where sub-tasks are involved.

if your parent tasks are known and few...

project = ABC AND "Epic Link" = Abc-123 OR parent in (abc-124, abc-223, abc-321...)

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 17, 2019

Yes, and... to make it a bit less manual (without an addon)

  1. Run a query to get all of the stories, bugs, tasks assigned to the epic
  2. Export the issues, and open the export file
  3. Grab just the keys, and use your favorite editor to turn it into a comma-separated value (CSV) list
  4. Use the query @Jack Brickey suggests above by pasting in the CSV list

Best regards,

Bill

Jack Brickey
Community Champion
September 17, 2019

Yep good tip

John Eckhoff September 18, 2019

Parent task are many , any advise on an add-on?

0 votes
Jack Nolddor _Sweet Bananas_
Atlassian Partner
October 26, 2019

Hi John, in adittion to the Jack suggestion:

If you want to avoid to manually type every Epics affected by your criteria, you must go for a third-party plugin to create such a complex query.

 

i.e. using JQL Booster Pack (FREE), you need to type the following:



(type = Epic AND project = ABC) OR issue IN issuesInEpics('type = Epic and project = ABC') OR issue IN subtasksOf("(type = Epic and project = ABC) OR issue IN issuesInEpics('type = Epic and project = ABC')")

 

The above query will retrieve:

1.- Any Epic within the project ABC,
2.- Any subtask directly created under those epics,
3.- Any stories/issues within those epics on the Epic Link field regardless of the project
4.- Any subtasks created under issues matching point 3 regardless of the project

Regards

Suggest an answer

Log in or Sign up to answer