Is it possible to frame a JQL query (or any other mechanism) to search for stories that are not in an end state even though all their children/sub-tasks are marked as completed (in an end state)?
Hi @Swaroop Rao and welcome to the community.
I do not believe you can do this with out-of-the-box Jira, and...
Yes, you can write a query to do that if you have an add-on like ScriptRunner. That will allow you to build a nested query checking the subtasks' status. Here is another community posting which shows an example:
https://community.atlassian.com/t5/Jira-questions/Display-all-the-stories-which-are-not-closed-but-show-sub-tasks/qaq-p/595583
Best regards,
Bill
Hi @Swaroop Rao ,
We can get these type of results by using the plugin JQL Search Extensions for Jira
following query will give you the required results.
Jql : ( issuetype = Story AND status = "Open") AND subTaskStatus = Closed (for Cloud)
( issuetype = Story AND status = "Open") AND issue in subTaskStatus("Closed") (for Sever)
issue in subTaskStatus(
"
https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/30497099/JQL+Reference+Server#JQLReference(Server)-SubTaskStatus
https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/3375124/JQL+Reference+Cloud#JQLReference(Cloud)-SubtaskStatus
Regards,
Sudhakar
Yes. You will need an addon for this e.g. scriptrunner
Thank you, Bill & Jack. I decided to use the REST API to build a small app to do this. It seems to be working correctly but I'll have to do a bit more testing.
Pff... and again - common issue to be solved by plugin. that is needed for only a few people/users, but has to be paid for all kind of users. Nah, won't do - will be best to eventually look for/suggest other tooling as a whole...
@Swaroop Rao
Hello, is your requirement complete with REST API ?
Please let us know.
It looks like you're new here. Sign in or register to get started.
