Filter on sub-tasks when parent summary does not contain certain words

Question

I am trying to filter on tasks with all of my statuses created after a certain date, however I want the sub-tasks excluded from the filter when the parent tasks contain the word "test".

Here's my query that isn't throwing an error, but it is displaying the sub-tasks where parent tasks contain the word "test".

project = jvccr AND status in (open, closed, cancelled, approved, "awaiting implementation", "awaiting approval", rejected, implementation, "awaiting implementation details") AND created > "2018/01/01 00:00" AND summary !~ test ORDER BY key DESC

II need a way to tell it "don't give me sub-tasks with status approved or rejected IF the parent summary contains the word test".

Thanks in advance.

Allison Vess · Answer

Thanks Tarun and Kian.   I just wish Script Runner was Free.  (we're on tight budgets here). :)

Tarun Sapra · Answer

Hello @Allison Vess

You can easily do this if you have Script Runner plugin installed on your machine.

"don't give me sub-tasks with status approved or rejected IF the parent summary contains the word test"

NOT (issueFunction in subtasksOf("summary ~'test'") and status in (approved,rejected))

Kian Stack Mumo Systems · Answer

Allison,

If you don't have a plugin, this is not possible.

I know of at least one plugin that can perform this. Scriptrunner has unctions that can query for "SubtasksOf" a given query. You could use that to search for "Subtasks of parents not containing test".

There may be other plugins that can accomplish this (such as the "JQL Tricks") but I haven't tried that. I know scriptrunner can do it for sure.