How to filter for tasks and sub-tasks assigned to the current user for open sprints?

[Frank]

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

[John Funk · Accepted solution]

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]

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?