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?



Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

818 views 5 17
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot