Hi,
Thanks in advance. I would like know if anyone has an JQL to search for all the Stories but list only those which has sub-tasks associated with them.
Best,
Rathna
This is not possible by default in JIRA. You will need a plugin like JQL Tricks. With JQL Tricks, you will do:
issue in hasSubtasks()
You can find similar plugins for server and cloud JIRA in the marketplace.
Hello,
You would need an add-on as Jobin said. There are multiple add-ons on the marketplace. You could use JQL Tricks, Adaptivist ScriptRunner or Power Scripts.
If you were on Jira Server/Data Center and you had the Power Scripts add-on, you could write your own JQL function. You would need to create a script file called hasSubTasks.sil with a code like this
string [] keys = selectIssues(argv[0]);string [] ret;for(string k in keys) { if (size(subtasks(k)) > 0) { ret += k; } }return ret;
Then you could use this function during search like this:
key in silJQLList("hasSubTasks.sil", "project = SCRUM")
You can change the script file to comply to any logic you need. You can find more information on the Power Scripts add-on here:
https://marketplace.atlassian.com/plugins/com.keplerrominfo.jira.plugins.jjupin/server/overview
Just another thought on the solution to your question.
you can check our Epic Finder add-on, please take a look here:
Function that may help you is efEmptyStories:
issue not in efEmptyStories("project = TEST") and issuetype = Story
You can find more information about Epic Finder add-on here.
Best regards,
Lime Trees Support Team
First off thanks ( Jobin Kuruvilla, & Alexey Matveev) for your responses.
My Apologies, that I have not mentioned that I was using script runner plugin. I found the below code and it worked.
issuetype = Epic and issueFunction in hasSubtasks()
Posting this so that someone can find it useful.
Rathna.
It looks like you're new here. Sign in or register to get started.
![Photo of Jobin Kuruvilla [Adaptavist]](https://us.v-cdn.net/6038660/uploads/avatars/17/c4/n17c4b8c7de7da6cee02bd69e8a3b017b.png)
