How do you filter issues to find stories without sub-tasks

I would like to create an issue filter that shows stories in the current sprint that do not have any sub-tasks assigned.

Something like this...
fixVersion = earliestUnreleasedVersion("DSI") and type = Story and ...???

Where ??? ~= childCount < 1 or children = YES

3 answers

1 accepted

1 vote
Accepted answer

JQL Tricks Plugin, a commercial one, has a hasSubtasks method that you can use for this.

you can also use the Craftforge JQL Functions Plugin to detect subtasks of a story:

and the best of all, it's Free :)

Just as an update: This Plugin is no longer free. It is now a paid app.

really!?! god dammit. thanks for sharing Michelle

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.

Doesn't work.  Error message received is that issueFunction does not exist

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,946 views 19 22
Read article

Atlassian User Groups

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!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you