Query Help

Question

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

Trudy P Claspill · Answer

@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.

K Vivek Rao_y5kp3p · Answer

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 P Claspill · Answer

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?