JQL for getting stories with out subtasks-Jira cloud

seethamraju September 29, 2019

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

3 answers

1 accepted

0 votes
Answer accepted
Thomas Magny-Garcia
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 1, 2019

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

Capture.PNG

 

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

 

Hope it helps !

seethamraju October 1, 2019

Hi @Thomas Magny-Garcia 

 

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

 

Thanks,

Raju 

0 votes
Jack Nolddor _Sweet Bananas_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
September 30, 2019

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.

0 votes
fran garcia gomera
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 29, 2019

scriptrunner has a JQL function 

issueFunction not in hasSubtasks()

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

seethamraju September 30, 2019

Hi, i want to get JQL with out any plugins

seethamraju September 30, 2019

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_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
September 30, 2019

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

fran garcia gomera
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 30, 2019

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

Suggest an answer

Log in or Sign up to answer