need a JQL Query to find issue having single value selected for multi select custom filed

[Csyuvraj@10]

Hi All 

Provide a query to check that  each of existing Jira issue refers to only one value selected for multi select custom filed 

Thanks 

Yurvaj

[Planck Lee_LiJiao_]

I want to know the answer too. However, I can't find it alothough I spent a lot of time on it.
And, sometimes, I really hate JIRA.

[Arkadiusz Baka]

For options ex.(a,b,c,d)You can exclude options  ex. cf not in (a,b,c)

Result : only option d

[Planck Lee_LiJiao_]

I have a multiple-choices select list with more than 100 options, and I will add some every week. How can I just search issues with only option-A selected?

[Arkadiusz Baka]

@Planck Lee_LiJiao_  do you have scriptrunner?

[Niranjan]

Hi Csyuvraj@10 - Welcome to the community. You may need to create scipted field (script runner) and use it in JQL. Please find a similar discussion

https://community.atlassian.com/t5/Jira-questions/Number-of-options-selected-in-multi-choice-field-via-JQL/qaq-p/130240