Hello. I would like to know how can I get all subtask by stories and filter by sprint. 1. My types. 2. I have some stories with subtasks. 3. When I want to see all types, I can saw it. When the original JQL : project = "DM" ORDER BY created DESC 4. When I want to filter by sprint the subtask disappear. project = "DM" AND sprint = 382 ORDER BY created DESC. 5. ON the report for work in progress I can't see the subtask too. Is possible to do the thing that I want. Thanks.

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; } } }

How to get all subtask by stories for sprint ?

devsebastianvz

Hello.

I would like to know how can I get all subtask by stories and filter by sprint.

1. My types.

Screenshot 2025-01-23 at 9.20.51 AM.png

2. I have some stories with subtasks.

Screenshot 2025-01-23 at 9.21.06 AM.png

3. When I want to see all types, I can saw it. When the original JQL : project = "DM" ORDER BY created DESC

Screenshot 2025-01-23 at 9.21.23 AM.png

4. When I want to filter by sprint the subtask disappear.

Screenshot 2025-01-23 at 9.21.54 AM.png

project = "DM" AND sprint = 382 ORDER BY created DESC.

5. ON the report for work in progress I can't see the subtask too.

Screenshot 2025-01-23 at 9.32.56 AM.png

Is possible to do the thing that I want.

Thanks.

Accepted answers

Hannes Obweger - JXL for Jira

Hi @devsebastianvz,

welcome to the community!

It's been raised recently that for sub-tasks from team-managed projects, JQL searches based on sprints don't seem to work. This looks like a bug to me, and should probably be raised with Atlassian.

Is DM a team-managed project?

It's worth noting that sub-tasks are a bit special, in that they always "inherit" the sprint from their parent issue. I could imagine that our bug is somehow related to this this special behaviour.

Best,

Hannes

Danut M _StonikByte_

Hi @devsebastianvz,

Welcome to the Atlassian Community!

Unfortunately, filtering by sprint in team-managed projects does not work. It is a known limitation of Jira Cloud, see this bug: JRACLOUD-90898. Please up-vote this ticket with the hope that Atlassian will address it soon.

Danut

All comments

Hannes Obweger - JXL for Jira

Hi @devsebastianvz,

welcome to the community!

It's been raised recently that for sub-tasks from team-managed projects, JQL searches based on sprints don't seem to work. This looks like a bug to me, and should probably be raised with Atlassian.

Is DM a team-managed project?

It's worth noting that sub-tasks are a bit special, in that they always "inherit" the sprint from their parent issue. I could imagine that our bug is somehow related to this this special behaviour.

Best,

Hannes

Hannes Obweger - JXL for Jira

... and just to add to the above: If you're open to solutions from the Atlassian Marketplace, your use case would be easy to solve using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a long list of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.