Searching Custom Text field for partial matches

[Erin Blomert]

Hello Community!  This should be so easy and it's not working at all and making me crazy.

I am in a Company-managed product.  I have a custom text field, "Serial Number".  Serial number is set up using the Search Template "Free Text Searcher".

I want to search this field for a partial match, but it seems like this is just not supported.  For example, I want a serial number ending in 182.  Even "contains 182" would be fine, but I can not get that far.

The absolute ideal would be a way to get this to work using the top-right hand corner search bar instead of going in to the Advanced Search!

As I have failed there, here are my results in Advanced...

"Serial Number[Short text]" ~ 182 finds nothing, even though results do exist

"Serial Number[Short text]" ~ *182 pulls an error as * must be used in a string

"Serial Number[Short text]" ~ "*182" says that * is not allowed as the first character of a string

"Serial Number[Short text]" ~ "2*182" at least searches for the "2*" but actually ignores the rest of the string and I get results like 2014090 in addition to the desired result.

This does NOT seem complicated, but I can not believe it's just not possible...

Please help!

I should note that some serial numbers contain a '-' character and I have noticed that there is a bug fix request for failing to search such numbers.  Also crazy!  But I can not get it to work even with numbers that do not contain hyphens.

[Alexis Robert]

Hi @Erin Blomert , 

as you've said, the issue with JQL search is that you can't start the search with "?" or "*" wich are wildcards.

However, the following works to find any issue with ABC in the field : 

summary ~ "ABC"

I think maybe you forgot to use quotes around your search.

You can also vote for the feature to use "*" at the start of the search here : https://jira.atlassian.com/browse/JRASERVER-6218

Let me know if this helps,

--Alexis

[Erin Blomert]

Hi @Alexis Robert , this works for Summary and Description, but it returns no results for custom text fields. 

[Stephen Chisholm]

I have the same question ... I'll wait for Alexis' response.

@Alexis Robert