It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JQL for getting stories with out subtasks-Jira cloud


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




3 answers

1 accepted

0 votes
Answer accepted

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 !

Hi @Thomas_Magny-Garcia 


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




scriptrunner has a JQL function 

issueFunction not in hasSubtasks()

Hi, i want to get JQL with out any plugins

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.




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

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

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?


Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you