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

[Roy Martin]

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

[Jobin Kuruvilla [Adaptavist] · Accepted solution]

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

[Simon Brugger]

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

https://marketplace.atlassian.com/plugins/org.craftforge.jira.craftforge-jql-functions-plugin/version/20120623

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

[Michelle Hall]

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

[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.

[Joe Harmon]

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

[Jack Brickey]

Issuefunction is associated with Scriptrunner plugin