Exclude bugs with a particular label but not all bugs

Question

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 Answer

@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