With JQL, How to list all tasks and subtasks from the sprint?

[Michel Ribeiro Araujo]

hey guys! i'm trying to filter the list of issues to see only the tasks and subtasks from a specific sprint. But I dont get it how to do it... What I'm trying now:

project = JOBIEE AND sprint = 1299 AND issuetype in subTaskIssueTypes() and sprint in openSprints() ORDER BY status ASC, created DESC

but this return nothing.

Because my Jira is in portuguese, I almost found a solution with this:

project = JOBIEE AND sprint = 1299 AND issuetype IN (Tarefa, Subtarefa) ORDER BY status ASC, created DESC

But only get the "tarefa" which means the tasks. The subtasks (called "subtarefa") are children from tasks or stories. how to filter it?

Found something weird... If I remove the "sprint = 1299" from the JQL, I can see all the subtasks from the project include those which are on that sprint. 

[Trudy Claspill]

Hello @Michel Ribeiro Araujo 

Are you working with a Team Managed project or a Company Managed project?

Get that information from the View All Projects page under the Projects menu. Find your project in the list. What does it say in the Type column?

Experimenting in my own instance I found that a query like your second one:

project = JOBIEE AND sprint = 1299 AND issuetype IN (Tarefa, Subtarefa) ORDER BY status ASC, created DESC

...works in a Company Managed project but not a Team Managed project. This assumes that you have correctly specified the names of the issue types within the query.

This is a known bug documented here:

https://jira.atlassian.com/browse/JRACLOUD-90508

[Michel Ribeiro Araujo]

Team managed

[Trudy Claspill]

This is a known bug in Team Managed projects, documented here:

This is a known bug documented here:

https://jira.atlassian.com/browse/JRACLOUD-90508

[Michel Ribeiro Araujo]

Thanks for the answer. 

[Trudy Claspill]

You're welcome.

If my answer adequately addressed your question, please consider clicking on the Accept Answer button to mark your Question as Solved.

If you are still needing the information and are willing to consider a third party app, you could use something like ScriptRunner Enhanced Search. With that you could create a JQL that would select the standard level issues within the sprint, and then add a second part to the JQL to select the subtasks of those issues.

project = JOBIEE AND sprint = 1299 AND issuetype IN (Tarefa) or issuefunction in subtasksOf("project = JOBIEE AND sprint = 1299 AND issuetype IN (Tarefa)") ORDER BY status ASC, created DESC

https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search/scriptrunner-enhanced-search-jql-functions/links-and-relationships#subtasksof