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

[Allison Vess]

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.

[Kian Stack Mumo Systems]

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.

[Allison Vess]

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

[Tarun Sapra]

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))