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

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