JQL to obtain the sub tasks created in the last or current sprint

Irvin Mendez

Hi, I'm looking a JQL to obtain only the tasks created in the last sprint, when filter the tasks by sprint I get all the task include the carry over tasks, but I need only the created in this sprint.

I'm ussing this JQL but 

type = Sub-task AND project = STR AND reporter in (irvin.mendez) and (created >= "2020/06/03" AND created <= "2020/06/16")

Andy Heinzer

Hi Irvin,

I understand you are looking to find in JQL all the subtasks created during a sprint.  I am afraid your JQL explain does not indicate if the subtask created are part of any sprint or not.

If this sprint is in a next-gen project, then you should first be aware of this bug JSWCLOUD-18398 : Unable to search for sub tasks in a sprint on a next gen project.  Next-gen project based sprints currently won't be able to return subtask via JQL just yet due to this bug.

 

However, if this is a classic project, then you should be able to see that with something simply such as:

type=sub-task and sprint=4

With the sprint field, you can actually use the sprint name, but many times the autocomplete will change this use the id number of that sprint in question.  In my example, my "Sample Sprint 3" had an id number of 4 which serves to return all issues in that sprint.

You could also restrict this further to find the ones created during that time frame, such as with

type=sub-task AND sprint=4 AND created >= "2020/06/03" AND created <= "2020/06/16"

That should then be able to show you all the subtasks in that sprint that were created within the desired date range.   I removed the project and reporter fields from your query since sprints can technically contain issues from other projects and have different reporters.

I hope that helps.

Andy