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 ,
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)
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:
👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...
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