How to use subqueries on JQL

[Filipe Dziedicz]

I need to search for Sub-tasks where the parent task isn't Done

In plain SQL would be something like:

'where issuetype= Subtask and status = Done and parent not in (select id from project = ED and status !=done)'

I tried using "not in" and the function filter= <> but with no success 

[Kristján Geir Mathiesen · Accepted solution]

Hi @Filipe Dziedicz 

Pretty sure you can't do this with out-of-the-box Jira JQL. You will need 3rd party app to do this.

Best,
KGM

[Filipe Dziedicz]

Thanks for the reply, Is there any that you would recommend ?

[Kristján Geir Mathiesen]

Well, I know that ScriptRunner can do this, see here for example. Might be others out there too. Btw, I am not affiliated with ScriptRunner, just so you know :)

Please mark the answer correct if you are satisfied with it.

Thanks, good luck, and have a great weekend,
KGM

[mauricio.groth]

Hi @Filipe Dziedicz

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

Unfortunately, using JQL of Jira, you’ll not be able to do it.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all your subtasks whose parent is not done.

issue in subtasksOfParentsInQuery("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