Search Custom Field Value

I have created a custom field called "Case #" from the Text Field (single line) standard field type. This field only shows up in a single project and only has numeric-like values (e.g. Case # = 1234567).

I am trying to search for all issues with a specific Case # value. After reviewing much documentation, I'm able to do this with a JQL query as follows:

project = projectA AND "Case #" !~ 1234567

I have 2 questions:

1) My understanding is that the !~ operator is supposed to be mean "does not contain". So why is this bringing up the correct issues when used in the JQL? I would expect the ~ operator to bring the issues up, but it does not. This is the opposite of what the logic I expected.

2) Is there a way to have the custom field indexed so that it and its values show up in a basic search done from the general search screen opened on the left side of the page?

Thanks for the help and explanation!

1 answer

0 votes

Hi John,

The != operator performs a "fuzzy search" and works best on text-based fields.

Considering Case# is always numeric, have you explored the option of using a Numeric Custom Field type instead?

Regards

Bhushan

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Mar 28, 2018 in Jira Software

Can a company’s culture make or break agile adoption?

Can a new-to-agile team survive and thrive in a non-agile culture? If so, what advice would you give to those trying to be agile in a non-agile culture? What's the key(s) to success? Share your thoug...

17,626 views 18 20
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you