How to filter subtasks by sprint

[Mikala Hernandez]

I need to pull a report  that shows all subtasks filtered by sprint number. For example, I want to see:

- All subtasks that were completed in Sprint 1

- All subtasks that exist in the current active sprint

It's not possible to do this using Filters -> View all Issues -> Search, because subtasks are not assigned to sprints, only their parent issues are (even though subtasks do show a field identifying which sprint they belong to).

One possible work-around I came up with was to create a custom field (Sprint - Reporting) on Issues and subtasks, that automatically copies the value from the Sprint field. That way, I would be able to filter by that field. However, I am not able to figure out how to copy the value from the "Sprint" field to the custom field "Sprint - Reporting" using the Automation rules.

Is there any kind of work around that would provide a solution to my problem?

I am using Team-managed project.

[Sanjog Sigdel · Accepted solution]

Hello @Mikala Hernandez 

Welcome to the community.

You can filter your subtasks by sprint using a simple JQL:-

issuetype in subtaskissuetype() and sprint in opensprints()

This will list all subtasks types like sub-task, story-defect, test-case under open sprints. If you are running multiple sprints you will get tickets from different sprints. 

If you want from a particular sprint you can use this query instead:-

issuetype in subtaskissuetype() and sprint in(544,555)

Where 544, 555 are the sprint ids which you get after typing your sprint name inside parenthesis "Sprint 64".

Further more if you are looking for specific issue types among the sub-task issue types you can use this query:- 

issuetype in("Sub Task", Defect, Documentation) and sprint in(544,555)

[Mikala Hernandez]

Thank you so much, @Sanjog Sigdel

[Sanjog Sigdel]

@Mikala Hernandez 

Kindly Accept the answer so that people can take a reference for future.