Query for Sub-tasks assigned to me

[Saiyam Patel]

Is is possible to create a query that shows all the Sub-tasks assigned to me?

[Nic Brough -Adaptavist- · Accepted solution]

Oh, I think I see the problem now.

You have made the wrong assumption about what a quick filter is.  They allow you to drill-down into issues on your boards.  They narrow the existing search, not extend it.

There are two reasons your subtasks are not on the board

• Your board filter does not include them
• You are looking only at the backlog, where sub-tasks are not shown (because they're no use there, as ranking them outside their stories is nonsense)

Check the board config, it should show the filter for the board.

[Saiyam Patel]

Oh, I did not know that. Thanks a lot for your help Nic. Can you edit this query to only show my tasks that are open? I will add the query to a Filter and search for the sub-tasks that way. 

 issuetype in subtaskIssueTypes() and assignee = currentUser()

[Nic Brough -Adaptavist-]

You probably don't want to have a board query that excludes closed tasks, as it means your "done" column will always look empty.

Your board filter probably needs to be something as simple as "project = X".  The "done" column should contain the status that means a task is closed.

I'd then try the quick filter just "assigned to me" and maybe add a second one for "only show subtasks".  That will let you drill down into the board very simply.

[Saiyam Patel]

Got it. Thanks Nic. 

[Alexey Matveev · Accepted solution]

Hello,

You could write a query like this:

issuetype in subtaskIssueTypes() and assignee = currentUser()

[Saiyam Patel]

Thanks Alexey,

But it did not work for me. This does not show any results. 

I have a query that shows Issues with subtasks assigned to me. But in order to see those sub tasks I have to open that story and look for the sub tasks. 

[Nic Brough -Adaptavist-]

I'd guess that you're mistaking "issue is assigned to me" with "sub-task is assigned to me", and your sub-tasks are not assigned to you.

[Saiyam Patel]

There are sub-tasks assigned to me. I just cannot see them directly. To see them I need to open the Story and look for the sub-task assigned to me.

[Nic Brough -Adaptavist-]

The query Alexey gave will show you sub-tasks assigned to you.

My guesses as to why you might not see them are that

• You are making the incorrect assumption that a sub-task inherits the assignee of the story
• You are not using the built-in assignee field

[Alexey Matveev]

Could attach a screenshot of an issue, which you think is a subtask and assigned to you, but the JQL query, which I provided, does not return this issue?

[Saiyam Patel]

See the screenshots.

[Nic Brough -Adaptavist-]

I'm afraid those screenshots are not relevant.

Could you run a search (not a quick filter) for that query?

And show us the plain issue view of a sub-task you are saying is assigned to you but does not appear on your board?

[Saiyam Patel]

Hi Nic,

When I run a search I am able to see the results. All the sub-tasks assigned show up. 

Is there any way I can do the same with a quick filter on the board?