How to search for issues that have a given value in a multi-value field

[t m]

We have a custom field that allows us to select teams that are to work on an epic.

I am not the admin and not sure of the type used to create the field. However when editing an epic the field allows multiple choice from a list of teams, where multiple teams can be selected by holding the Ctrl key and clicking.

I am trying to create a swim-lane query that matches epics assigned on one of the teams, say "fooTeam" for example.

The following works fine for epics that are assigned solely on this team:

cf[12345] in (fooTeam)

However it does not match when this team, and any other team(s) are assigned. That is both fooTeam and barTeam are assigned on one epic.

How can create a query that

1. matches when the field is "fooTeam"
2. matches when the field is "fooTeam, barTeam, buzzTeam"
3. does not match when fooTeam is not assigned, regardless of if any other team is assigned (i.e. the field is "barTeam, buzzTeam")
4. does not match when no team is assigned (i.e field is empty)

Thanks for your help! /T

[t m · Accepted solution]

whoops, this isn't what was causing epics not to be included in my larger query XD