How to filter issues without sub-tasks

[Dmitry Budnik]

Hello,

I would like to create a filter for my developers. They need to have the ability to see issues without the estimate field being filled. It work fine for us with the query like this:

{code}

fixVersion in unreleasedVersions() AND assignee = currentUser() AND (( originalEstimate is EMPTY) and (remainingEstimate is EMPTY)) AND project != Nanocoding internal upgrades and status in (Open, In Progress) ORDER BY fixVersion DESC, key DESC

{code}

But for those tasks which have sub-tasks we do not use the estimate field. We use the values from subtasks.

How can we filter those issues which have no sub-task.

[Norman Abramovitz · Accepted solution]

You cannot do it without a plugin. You can vote for this to be in the base.

https://jira.atlassian.com/browse/JRA-24973

You might be able to do it with j tricks plugin hasSubtasks function.

I would try using the function with the NOT operator.

[Mohit Arora]

A possible solution: https://wiki.almworks.com/display/structure/S-JQL+Cookbook

but would need the Structure plugin

[d3rb3rt]

try 

issueLinkType not in (jira_subtask_outward)

works for me, no plugins

[Amit Namdhari]

Solution without a plugin.

Use below query as a Quick Filter from the Board Configuration.

issueFunction not in hasSubtasks() AND issuetype != Sub-task

It will sort out every story which has No or Zero sub-tasks.

[Mohit Arora]

issueFunction functionality is from a plugin & not part of standard JIRA