How to filter on multi select fields

[Robert Schutt]

I have a multi select field, which of course may have more than 1 selection. I want to know if the value "A" is selected, regardless of there being other selections made.  If I use field = "A" or field IN ("A") I get the same result and that result is only the records where "A" is selected and no other selection is made. In other words, the records having both "A" and "B" selected are not in the results returned. I've looked and looked and can't seem to find how filtering on multi select list can be done to get what I want. This seems like the most basic type of filtering one would want to do on a multi select field type, but I can't find it.

[Alexey Matveev · Accepted solution]

Hello,

I just checked. The IN operator lets you select all issues which have the A value selected. It does not matter if it is the only choice or there are other choices as well.

[Robert Schutt]

Thank you for testing this. I delved in further and see that my "A" that I was filtering on was actually two values that had gotten concatenated via some import issue (the value in the multi select list was "A C D" vs there being "A", "C", "D" as values). Thanks again for taking the time to respond. Have a great day!

[Alexey Matveev]

I am glad you solved the problem. If my answer helped you to solve the problem, kindly mark it as accepted. In this case other people with similar question will be able  to find this answer.

[Sascha Nothofer]

had same issue in context of Jira Workflow Toolbox "Condition on linked issues".
In this context the operators "in" and "=" results in "false" if multiple options are selected.
But it works fine if you use "like"/"~" instead!