When a custom field which has the options as drop down list is used in JQL query, having an issue.

[Giri Prasad]

I'm trying to execute the below query . And when used Reported by[which is a drop down field and has multiple options such as Customer, IV&V / TE, Factory , ME ...) for SWD and customer it is working but when using it for other drop down options such as ME or IV&V / TE or Factory ... I'm not able to execute the query.

(project = XXXXX) AND ("Reported By" != Customer AND "Reported By" != SWD AND "Reported By" = "IV&V / TE" )

[Trudy Claspill]

Hello Giri,

It is not working because the values contain special characters.

Refer to the "Restricted words and characters" section this article:

https://support.atlassian.com/jira-software-cloud/docs/what-is-advanced-searching-in-jira-cloud/

[Giri Prasad]

Hi Trudy Claspill,

Sorry for the delay in the reply .

Thanks for the reply. 

I have found the workaround solution for the same. I have applied the filters by selecting the options from the Advanced search.

[Muhammad Ali]

Hello @Giri Prasad Can you please help me with the work around? I am facing same problem

[Giri Prasad]

Hi @Muhammad Ali ,

Click on all issues in the project -> Go to advance search -> + More -> Select the categories you are looking for filter -> switch to JQL ...and save your filter.

If this not your case, Can you please elaborate your problem.

Regards

Giri