How to search for issues with custom fields?

[Peeya]

Hi,

I have created a custom field such MoSCoW rating and the values are Must Have, Should Have, Could Have, Wont Have and None. How do i search for the issues with any specific MoSCoW rating for instance all issues with Must Have as MoSCoW Rating? How would the query look like? 

[Stephen Wright _Elabor8_]

Hi @Peeya

JQL uses operators as part of its search queries - see a full list of those on this page.

So for example, if I wanted to find all issues which have the value "Should Have":

"MoSCoW Rating" = "Should Have"

Or if I want to find all issues which do not have the value "Could Have":

"MoSCoW Rating" != "Could Have"

And if I wanted to find all the issues which have no value in this field:

"MoSCoW Rating" is EMPTY

Just to note, JQL considers the operator != to look for a value in the field, and empty is not a value. So if you wanted to find all issues which were not equal to "Could Have", including those with no value - you'd need:

"MoSCoW Rating" != "Could Have" OR "MoSCoW Rating" is EMPTY

Ste

[Andre Gott]

Regarding custom fields, please see:

https://community.atlassian.com/t5/Jira-questions/Get-issue-details-by-passing-custom-fields-in-search-API/qaq-p/1139044

> Try this: rest/api/2/search?jql=cf[10302]

[Ashkan Malekly]

Hii @Peeya 

There are many ways for jql. But you can write for example "moscow rating" = "must have" and if you write moscow in advance search jira by defalt suggest you options of the custom field and if you want to search just one of the option you mast use = after the name custom field and if you want to include some options you must use in (must have, should have, could have)  after the name of custom field.