Query Help

[Spruha Shah]

Can you help to write a query that pulls in ALL subtasks that are open but their parent is CLOSED?

i need to get 2 filter queries: 

subtasks in a project which are open but their parent is CLosed. 

parent issues that are closed and their subtasks is not resolved

[K Vivek Rao]

For the below requirement , if you are on cloud you can try this 

subtasks in a project which are open but their parent is CLosed. 

Try this, make sure you replace the project KEY "ZING" with your project KEY and write back if you notice any issue\

project = Zing AND issuetype = Sub-task AND status != Done AND parentStatus = Done

[Trudy Claspill]

@K Vivek Rao 

Welcome to the Atlassian community.

"parentStatus" is not a valid filter field in Jira Cloud natively. Does it actually work for you? Perhaps you have a third party app in your environment or it is a custom field set up in your environment.

[Trudy Claspill]

Hello @Spruha Shah 

That is not possible if you have only native Jira functionality.

Do you have any third party plugins that extend the JQL capabilities, like ScriptRunner or JQL Tricks?

Your post tags indicate you are using Jira Server. What version of the product are you using?