Not able to exclude results from SubtasksOf containing a certain label

Question

Trying to do something like the below with Scriptrunner enhanced search:

issueFunction in subtasksOf("filter = ActiveEpics") AND labels not in ("DevOps")

I do not get any results. However when I remove the "NOT" it does only return the subtasks with DevOps. I suspect I somehow need to use IS EMPTY, but don't know where to put this without removing the results of the ActiveEpics Filter

Trudy P Claspill · Answer

What are the results of the query with the new clause added?

If you execute the query using just the issueFunction clause, does the result set include any sub-tasks where the Labels field includes 1..n values and none of the values included are DevOps?

ArjanN · Answer

Thanks for the quick reply, but that unfortunately didn't work. Still an empty result.
What I'm trying to achieve is basically filtering the result of the issueFunction to not include any subtasks with "DevOps" as one of their labels.
The interesting thing is that it does work if I just want to have the ones with "DevOps".

Trudy P Claspill · Answer

Try this

issueFunction in subtasksOf("filter = ActiveEpics") AND labels not in ("DevOps") and labels is not empty