Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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

1 answer

1 accepted

2 votes
Answer accepted
John Funk Community Leader Mar 17, 2021

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

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.

Like John Funk likes this
John Funk Community Leader Mar 18, 2021

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. 

Like Frank likes this

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Software

👋 Looking for 15-20 volunteers to test Atlassian training content

Hi everyone! Are you interested in beta testing Atlassian University’s newest (unreleased!) training course? We’re looking for 15-20 volunteers to test our newest training course, Basic reporting...

395 views 19 22
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you