nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

All comments

Trudy P 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.