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 filter for tasks and sub-tasks assigned to the current user for open sprints?

Frank_r8tojc

I would like to create a filter that lists all assigned work (tasks and sub-tasks). I am using this JQL

resolution = Unresolved AND Sprint in openSprints() AND Sprint not in futureSprints() AND assignee in (currentUser()) order by updated DESC

This works for tasks but it does not show sub-tasks. Even though the sub-tasks also are assigned to the same sprint as the parent task.

Help appreciated!

Frank

Accepted answers

John Funk

Hi Frank - Welcome to the Atlassian Community!

Would a user ever be assigned to a sub-task on that project that was not in the current Sprint? If so, why? If not, then you can modify the query to look like this:

(resolution = Unresolved AND Sprint in openSprints() AND Sprint not in futureSprints() AND assignee in (currentUser())) or (issuetype = Sub-task and assignee in (currentUser())) order by updated DESC

All comments

John Funk

Hi Frank - Welcome to the Atlassian Community!

Would a user ever be assigned to a sub-task on that project that was not in the current Sprint? If so, why? If not, then you can modify the query to look like this:

(resolution = Unresolved AND Sprint in openSprints() AND Sprint not in futureSprints() AND assignee in (currentUser())) or (issuetype = Sub-task and assignee in (currentUser())) order by updated DESC

Frank_r8tojc

Thanks John for the quick reply!

Point taken. Of course, tasks will probably not be assigned if they are not in the current sprint. While I was playing with the filter, I was just surprised to see the subtasks are not coming up when filtering for sprints even though the subtasks themselves (as they have a link to the sprint) and the UI (by providing type = all as option) suggest that they should. I think that all goes back to the fact that subtasks are just an after-thought and not first-class citizens.

I will be able to work around it.

John Funk

There's also this open feature request for showing the Sub-tasks in the Backlog:

https://jira.atlassian.com/browse/JSWCLOUD-7992

You should vote for and follow that one.

M Fahima Hanifa

Hi Frank, I have the same need as yours and haven't get the jql yet, would you share your "work around" here?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud