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
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 !
Thanks for the reply, even though its not apt solution, but somehow, it helps me.
Thanks,
Raju
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
scriptrunner has a JQL function
issueFunction not in hasSubtasks()
https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_hassubtasks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Note that hasSubtasks() is only available on Jira Server, for Cloud see my answer below.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I didn't notice you were using cloud. Anyway, you are going to need to add some plugin to do that
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.