Help on a complex (for me) JQL statement? I need a filter to show me Open Stories that contain children sub-tasks, at least one of which is not Open.

Community
Q&A
Jira
Questions
JQL to find open stories containing a sub-task which is not Open?

When will Jira be back up?

Jira has been down all morning. I don't see any discussions about it - is there an official thread for the outage? When will Jira be back up?

Answer

Like Be the first to like this

716 views

Atlassian recommended

Hello,
We apologize for the length of this ongoing incident and for not being more proactive in our communication with you. We understand how mission-critical our products are for you and want to make sure we are relaying the most accurate information possible.

While we really want to get in front of you live to answer your questions, we are prioritizing getting customers up and running first and foremost. We will host an AMA (Ask Me Anything) after we get all of our customers fully restored.

In the meantime, please add your questions here and we will respond as quickly and transparently as we can. Some questions may not be answered until we do an official PIR, but we will let you know that and answer as much as we can now.

Our Chief Technology Officer Sri Viswanath has posted a blog about this incident with more background and details, and our team is working around the clock to move through the various stages for restoration.

We are working 24/7 to restore your service. Thank you to those who have been sharing all the information you know from your support requests. Thank you for being open, honest, and caring for your fellow Community members. This speaks a lot about what makes Community a special place.

Lastly, if you're unsure if a support request was raised on your behalf, please let me know, and I will personally check. My team and I went through all Community posts related to this incident to ensure everyone's site had a support request.

Regards,
Stephen Sifers | Product Lead, Community

3 answers

1 accepted

0 votes

Answer accepted

It is not possible on onDemand because it involves searching parent stories based on subtask status. On downloaded version, there are few plugin which might help.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

ok, thanks!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

There is an Add-On for JIRA On-Demand, that has the requested functionality - https://marketplace.atlassian.com/plugins/jql-pro

See the screenshot - you can choose the Subtask status. It will return you the list of parent issues. Then you can use the keys of the parent issues to filter them with the native JQL.

Screen Shot 2014-09-14 at 8.14.39 PM.png

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Wouldn't this work?

type = story AND issue in subtask("status != open")

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

thanks, but ondemand says: "Unable to find JQL function 'subtask(status != open)'."

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • b-pos465 likes this

@Marissa McWaters What plugin do you have that gives you the subtask JQL function?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

When will Jira be back up?

3 answers

1 accepted

Suggest an answer

Was this helpful?

Thanks!

TAGS

Community showcase

Atlassian Community Events