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

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

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 !

Hi @Thomas Magny-Garcia 

 

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

 

Thanks,

Raju 

scriptrunner has a JQL function 

issueFunction not in hasSubtasks()

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_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.

 

Regards,

Raju

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?

Regards.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

273 views 1 2
Join discussion

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