How to have the list of issue wich contains subtaks by JQL ?

[Aurélie Pilette]

Hello

Context :

I create a subtask called "retourrs"

I install the okugin board subtask

When I go an issue, if i select this addon, I can create several subtask.

My need :

I would have the list of issues having at least one subtask for which the status != done

Question :

Do you know if there is a main to have it ?

Thanks a lot !

[Florian Bonniec · Accepted solution]

Hi @Aurélie Pilette 

I would say that the folowing JQL then displaying it in List View with "Parent" field as column should contains issue with sub-tasks != Done.

parent is not empty and status != Done

Regards

[mauricio.groth]

Hi @Aurélie Pilette 

I’m Maurício, a support engineer at Digital Toucan and I’m here to help you.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all your parent issues that have at least one subtask with status != done

issue in parentsOfSubtasksInQuery("status != done")

Please contact our support if you have any other questions about this query. 

We’ll be happy to help you!
Best regards,
Maurício

[Aurélie Pilette]

it doesn't work