JQL - Select issues where no subtask is assigned to the current user

[Anthony Sennett]

I would like to select all tasks assigned to the current user, where no subtasks are assigned to the current user. This will let me make a report that warns a developer if they are currently accountable for a functional user story, but not working on any technical subtasks related to it.

I thought it would be this (using the Scripted JQL functions):

assignee = currentUser() and (issueFunction in parentsOf("assignee != currentUser()"))

Unfortunately this subquery does not include unassigned subtasks, despite the assignee presumably being null in this case. I tried experimenting with multiple issueFunction clauses, but that seemed like a bit of a rabbit-hole when what I want is not that complicated.

An example of what I want in SQL would look something like this:

select distinct t.* from Task t join Subtask st using (t.Id = st.TaskId) where t.AssigneeId = CurrentUserId and st.AssigneeId != CurrentUserId

If you're a SO user, I also posted the question here. http://stackoverflow.com/q/24356644/614523

[Vijay Khacharia · Accepted solution]

Can you try this?

issuefunction in parentsOf("assignee != currentUser() or assignee is empty") AND assignee = currentUser() and not (issuefunction in parentsof ("assignee = currentUser()"))

[Vijay Khacharia]

Hi Anthony,

Here is the JQL that would work. You can use an OR for assignee to include also the empty assignees.

issuefunction in parentsOf("assignee != currentUser() or assignee is empty") and assignee = currentUser()

Hope this helps.

Vijay

[Vijay Khacharia]

Hi Anthony,

But this is what my query does. It checks if the subtasks have assignee not equal to current user and returns all the parents, and then i check for assignee of task to be the current user.

Is your requirement that none of the sub-tasks should be assigned to the current user?

Vijay

[Anthony Sennett]

Thanks for your continued input. I don't think so. I have a task, and I am assigned to the task. The task has two subtasks. I am assigned to one subtask, and the other subtask has no assignee. Using your query the task will get returned, when I require it not to be.

[Anthony Sennett]

Hi Vijay. Thanks you answer. Unfortunately that is not quite what I am looking for, as your query returns tasks that have a subtask that is assigned to the user. If the user is not assign to any subtask of his tasks, then the query should return, otherwise it should not.

[Anthony Sennett]

Yes - none of the subtasks should be assigned to the current user.

[Anthony Sennett]

If you add your answer to the SO question I shall also give you that karma ;)

[Anthony Sennett]

Great that works. Thanks so much for your help. Edit your answer to be this and I'll mark it as correct.

[Vijay Khacharia]

Probably you can add Karma here too :) on SO you already put the answer rite?

[Anthony Sennett]

I did, but if you put yours I'll delete mine.

[Anthony Sennett]

If you add your answer to the SO question I shall also give you that karma ;)