Checking for presence of check box in multiple check box filed

[Pawel Veselov]

Hi.

I have a multiple checkbox field, PM Expose.

I have defined two options for this field - In Fix List and Parked.

I'm now having issues being able to search for issues that have one of the options *not set* in the field.

Query

(project = xxx) AND (description ~ inbanner OR description ~ in-banner) AND Status not in (Resolved, Closed) and ( Severity = Blocker)

returns issues disregarding it's PM Expose value - OK.

Query

(project = xxx) AND (description ~ inbanner OR description ~ in-banner) AND Status not in (Resolved, Closed) and ( Severity = Blocker) and PM Expose not in (Parked)

only returns issues that both have *something* in PM Expose list, and that something is not Parked.

What's the best way to query issues that do not have a certain check box checked in a multiple checkbox field?

Thank you.

[Natalie Hobson]

(project = xxx) AND (description ~ inbanner OR description ~ in-banner) AND Status not in (Resolved, Closed) and ( Severity = Blocker) and (PM Expose not in (Parked) or PM Expose is empty)

But you will need to ensure that if you have set your custom field to only be applicable to certain projects or issue types, that your search query only covers tickets that are valid for the custom field.