Quick Filters JQL not working

[JON LEVETT]

Hi,

I have the following allowed as Labels:

BUKGEN BUKCRA BUKHF BUKCA BUKCL BUKBB BUKCARDS

I want to create a Quick Filter to identify if anyone put something in the Labels field that is none of these (7).

The JQL's I created were this:

(1) labels NOT IN (‘BUKGEN’, ‘BUKCRA’, ‘BUKHF’, ‘BUKCA’, ‘BUKCL’, ‘BUKBB’, ‘BUKCARDS’) AND labels NOT EMPTY

(2) labels != BUKGEN OR labels != BUKCRA OR labels != BUKHF OR labels != BUKCA OR labels != BUKCL OR labels != BUKBB OR labels != BUKCARDS AND labels NOT EMPTY

But neither work ? Any suggestions very welcome ....... :)

Ps they do filter out the missing cases (nulls) where labels is blank.

[Raynard Rhodes]

You just need IS NOT. The below should work.

labels NOT IN (‘BUKGEN’, ‘BUKCRA’, ‘BUKHF’, ‘BUKCA’, ‘BUKCL’, ‘BUKBB’, ‘BUKCARDS’) AND labels IS NOT EMPTY

[Ignacio Pulgar]

Provided that a given issue may have both allowed and forbidden labels at the same time, and that new labels can be created on the fly, there's no accurate way to obtain all info you want with a mere click on a quick filter's button, disregarding its JQL.

You could create a pie chart fed by the board's filter based on Labels field, for easily detecting any other disallowed labels.

However, by creating a custom field (or even by using Components) you may remove the need for having to review the values, as you may create just the allowed values, therefore preventing the addition of any other undesirable values.

[JON LEVETT]

Hi Ignacio, this sounds ideal (thanks). Is there a link that you could share which details how to go about creating a custom field and the restricting content (create a 'pick list' or drop down etc) ?

[Ignacio Pulgar]

A Jira Administrator account can create a new custom field like described here:

https://confluence.atlassian.com/adminjiracloud/adding-editing-and-deleting-a-custom-field-776636410.html

If the field should contain just one of the desired values at a time, I suggest to create a custom field of type 'Select List (Single Choice)'.

If the field may contain more than one value for the very same issue, then use a Select List (Multiple Choices) custom field.

Once created, it should be configured:

https://confluence.atlassian.com/adminjiracloud/configuring-a-custom-field-776636423.html