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 vote

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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published May 21, 2018 in Jira Software

How large do you think Jira Software can grow?

Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...

1,238 views 10 18
Read article

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