Need help with multi-select custom field JQL query

[Bre Leinbach]

Hello, I need help with a JQL query. I have a custom field multi-select list with a handful of options. The field is not always needed so on some issues the custom field is blank. On other issues more than one option is selected.

I would like for issues with "option 10" selected to be excluded from view on the board. 

If I use the below query, it hides issues with "option 10" selected but also hides the issues with nothing selected. 

project = KEY AND "customfield[Select List (multiple choices)]" not in ("option 10")

Is there a query which will show the blank customfield issues or should I just create an additional custom field that has "option 10" instead?

[Kseniia Trushnikova · Accepted solution]

Hi @Bre Leinbach,

Just add OR "customfield[Select List (multiple choices)]" is EMPTY to your filter:

project = KEY AND ("customfield[Select List (multiple choices)]" not in ("option 10") OR "customfield[Select List (multiple choices)]" is EMPTY)

[Bre Leinbach]

Thank you this worked exactly like I needed! I didn't think to separate out the EMPTY from the "option 10" request.