JQL for getting stories with out subtasks-Jira cloud

[seethamraju]

Hi,

Can any one help me in sorting out JQL for getting list of stories which are not having any subtasks (with out being admin).

Thanks in advance

Regards,

Raju

[Thomas Magny-Garcia · Accepted solution]

Hi @seethamraju 

It may be tricky but you should do this using the "subtasks" column...

If you use this kind of query, you will have all stories ordered by subtasks

 issuetype = Story ORDER BY subtasks DESC

Then with the "Sub-tasks" column, you may show the subtasks, then you only have to get the stories that interest you (via an export for instance...)

I understand it is not the best, but you know, it may work !

Hope it helps !

[seethamraju]

Hi @Thomas Magny-Garcia 

Thanks for the reply, even though its not apt solution, but somehow, it helps me.

Thanks,

Raju 

[Jack Nolddor _Sweet Bananas_]

Hi seethamraju,

Sadly I believe this is not possible without a third-party app.
You can use ScriptRunner for Jira (PAID) to achieve what you are looking for.

After installing Script Runner, try:

type = Story AND numberOfSubtasks = 0

Does it work?

Regards.

[fran garcia gomera]

scriptrunner has a JQL function 

issueFunction not in hasSubtasks()

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_hassubtasks

[seethamraju]

Hi, i want to get JQL with out any plugins

[seethamraju]

If i am using above JQL, i am getting error message like this.

Field 'issueFunction' does not exist or you do not have permission to view it.

Regards,

Raju

[Jack Nolddor _Sweet Bananas_]

Note that hasSubtasks() is only available on Jira Server, for Cloud see my answer below.

[fran garcia gomera]

I didn't notice you were using cloud. Anyway, you are going to need to add some plugin to do that