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
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?
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Every time you release software, there's a bit of risk – that there's a bug, that something breaks, or that the feature doesn't resonate with customers. Feature flagging helps make high stakes s...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG