Filter on a Custom Field Multiple Checkbox

[Dennis Harper]

We review bug lists on a regular basis and want track which ones we've reviewed, to filter them out of the list. I created a Custom Field using the Multiple Checkbox format and called it "Triage".  It has 2 states: "Done" and "Defer".

Now I want to filter out those bugs which as flagged as "Done".  In the bug filter query I add:

AND "Triage" != "Done"  (with the quote marks).

The result is EVERYTHING disappears.  All bugs in the list are gone, whether they are marked as DONE or not.

Is this the correct syntax for this filter?  I cannot make this work what ever i do.

Thanks!

[Warren · Accepted solution]

Hi Dennis

You need to account for issues where neither of the Triage items are ticked, so

("Triage != "Done" or "Triage" is EMPTY)

should give you what you want

[Dennis Harper]

Works perfectly!  Thanks Warren.  I wish this stuff was documented a bit better, especially Custom Fields.  This answer is correct!