CODEWITHSUNDEEP
jql
ggonmar
ggonmar

Reputation: 839

JQL to search subtasks of not completed stories

I am trying to create a custom search that lets me see the subtasks I touched of tasks that are still not done. I have the two queries sorted out:

q1 -> status changed by [username] after -7d

q2 -> status != Done

I tried 

status changed by [username] after -7d and Parent in (status != "Done")

But it throws an error...

I dont know how to apply the search correctly. On pseudo sql, it would be

Select * from tasks where 
    ( editor=[username] AND
      parent_task = (select taskID from tasks where status != "DONE")

Any idea as on how I can do this?

Upvotes: 3

Views: 233

Answers (1)

vinS
vinS

Reputation: 1475

Unfortunately your requirement cannot be achieved using native JQL. You can use a plugin like ScriptRunner, in order to fulfill your requirement.

Upvotes: 1

Related Questions