JQL to exclude a value of a custom field of type Select List (multiple choices)

Question

I hav a custom field of type Select List (multiple choice)

I'm able to query, "Field_Name" = "Value_1" fine. But I want to just exclude Value_1. The != operator doesn't work.

Also tried the  issueFunction in issueFieldMatch(subquery, fieldname, regex) but not sure how to represent the ! (NOT) a selected option in the regex.

Appreciate any help!

Daniel Ebers · Answer

Hi @Kalai

I found a related Bug which seems to imply that also a wildcard is involved, though.
Are you saying that the query just not works properly as soon as a slash ('/') is in one of the values of the field you are querying for? Other way around: "Value_x" works - or was this just an example.

I think we need the following from you:

Could you please list the complete JQL query here that is troubling - probably alongside with the values of the select list (it is fully okay to anonymize them),

Regards,
Daniel

Kalai_ik83lc · Answer

@Sreenivasaraju P  Thanks for the response. Yeah that didn't. work for that particular value "Not exists/NA" something. like that.... more details in my comment below. Not sure if it is the "/" and if there is any way of escaping it.

Kalai_ik83lc · Answer

After some trial and error. Two observations:

1.  ( "Field_Name" not in ("Value_x")) works for most of the. cases, just not the one I want probably because it has a "/" in it?

2. For the case with the. "/" in it when I do  ("Field_Name" is EMPTY or  "Field_Name" not in ("Value_1")) it works fine.

I'll try removing the "/" or create one more item in drop down with "/" and see how it goes to test out no. 1.

Any insights?