Unable to Search "Root cause" Select List (single choice) field value in JQL query

[Anuradha]

Hi, 

I want to search for Bugs in a Jira project with "Root cause" set to Requirement.

but i see no operator is supporting this field. I see below error.

"The operator '~' is not supported by the 'Root cause' field"

we have below values for the field.

Could any one please help?

Regards,

Anuradha

[Jack Brickey]

Hi @Anuradha , Root cause must be a custom single or multi-select field. In JQL you should be able to search for issues that have "Requirement" as follows.

"Root cause" = Requirement

if you are unable to do so please share screenshot of the JQL search

[Anuradha]

Hi @Jack Brickey ,

Yes, it is custom multi-select field. But still is not working :(. Screen shot below

[Jack Brickey]

Interesting... would you happen to have any other multi select field that you could test with? Also, when you begin to type "Root cause" and "Requirements" do they show in the auto-complete list?

[Anuradha]

Yes, We have "Development Team" field.

also "Root cause" field as below:

I even checked by using the custom field ID to search but its not working.

While typing the "Root cause" Field its shows in auto complete list as below

but when type "=" it say as below error:

[Jack Brickey]

Ok I think I see your issue. It appears that you have two root cause custom fields. This really is not a good idea at all. I suspect when you are entering root cause in your JQL you are getting the wrong one. Try selecting the correct one.

[Anuradha]

No Jack, I tried both, still see same. Here C is CAPS in this field. Yes there are two fields, but naming convention is different.