You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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.
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)