JQL Filter exclude standardtype and subtask

Question

Hi guys,

we use following filter to find tickets excluding bugs and their regarding subtasks:

issue not in parent("issuetype=Bug") AND type != Bug

We added one more Bugtype with the name "Bug - customer depending".

Can you tell me how I have to change the filter that the new bugtype will be also excluded from the filter and the regarding subtasks?

I tried with

issue not in parent("issuetype=Bug") OR issue not in parent("issuetype=Bug - customer depending") AND type not in (Bug, "Bug - customer depending")

but I get an error message "Invalid JQL Query in function: parent"

I tried different versions but nothing will work...

Thank you in advance!

Cheers

Lars

Lars Blaschka · Answer

Hi Jack,

thanks for your reply. Your suggestion almost works, I already tried it before my post here. Yo have to adjust it a little bit:

issue not in parent("issuetype=Bug") AND type not in (Bug, "Bug - customer depending")

Here is the problem, that this filter excludes all Bugs and their subtasks And the new type "Bug - customer depending". BUT it includes the subtasks of the new type "Bug - customer depending".

I need a way to exclude them too, but I cant get it running.

Jack Brickey · Answer

sorry let me back up as I'm a bit confused.

so you indicated that issue not in parent("issuetype=Bug") AND type != Bug was working for you prior to the new bug type and as such I was assumming that you were using some addon that supports "parent()" function as I it isn't there OOTB. Can you confirm that the initial query is in fact working sans the new bug type?

If it does work and all you wish to do is add a new type that is of issuetype Bug then maybe the following...

issue not in parent("issuetype=Bug") AND (type not in (Bug, Bug - customer depending))

Lars Blaschka · Answer

no, i think its impossible to get any results with this query, because you search for bug and exclude it in the second part....