The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
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)
Regards,
Sudhakar
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
Best regards,
Bill
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
👋 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 eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.