Exclude bugs with a particular label but not all bugs

[Maria.Trofimchuk]

Hi, 

I'm struggling with the following requirement:

I need to exclude the bugs with UAT label from issues of a particular project (for using the filter in timesheets).

However, I need bugs without UAT label included (as well as bugs with empty labels). 

And I need other issue types with UAT label included. 

I'm trying several options, e.g. 

project = "XXX" AND NOT (labels =UAT AND issuetype=Bug) AND(labels Is EMPTY) ORDER BY issuetype ASC

It returns only 2 bugs with 1 label "security". Other issues with UAT label are included. 

Could anyone help me with it?

[Derek Fields (RightStar) · Accepted solution]

@Maria.Trofimchuk Welcome to the community.

The JQL that you are looking for is 

project = "XXX" AND (NOT (labels =UAT AND issuetype=Bug) OR (labels Is EMPTY)) ORDER BY issuetype ASC

This returns all of the issues in project XXX where the issue is either

* Not a Bug with the label UAT, or

* An issue that has no labels at all

You could also write this as 

project = "XXX" AND ((labels is EMPTY AND issuetype=Bug) OR (issueType not in (Bug))) ORDER BY issuetype ASC

Both should return the same results

[Maria.Trofimchuk]

Hi Derek,

Thanks a lot for your help!

It worked.