Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to search for issues with custom fields?

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? 

2 answers

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

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.

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you