Custom Field Select List Multiple Choice Search

DanaF

I have a couple of Select List - Multiple Choice Custom Fields.

I am trying to do a search where custom field - Inspector = BOTH Bob and Jane

This is what it creates when I select the 2 individuals.

"Inspector" in ("Bob", "Jane") order by created DESC

I cant seem to get the Syntax down for this. 

I am using JIRA Cloud

Any suggestions?

JIRA Error 2.png

Nic Brough -Adaptavist-

"z in (x,y)" is an or-type compound, it's asking the question "is Z in (x or y)?"

I think you need to try "inspector = Bob and inspector = Jane"