Unable to search "Short text" custom fields (no error message)

Raphaël NORYNBERG

Hi everyone !

It seems like it is impossible to search in any of my custom field "Short text" with the "~" operator in JQL mode.

I don't understand why, am I doing anything wrong ?

Here is an exemple of request that should give me a result but display nothing :

project = Eezytrace AND "Date de création[Short text]" ~ "2023"

I have a lot of issue in this project, with this field containing "2023-05-dd", "2023-04-dd" etc...

I tried another custom field "short text",only filled with letters but I had the same result, and what I find odd is that when my request is like below, it works just fine...

project = Eezytrace AND "Date de création[Short text]" is not EMPTY

Thanks in advance for your help !

Trudy P Claspill

Hello @Raphaël NORYNBERG 

Here is an article that goes into more detail about searching text fields.

https://support.atlassian.com/jira-software-cloud/docs/search-for-issues-using-the-text-field/

When you encapsulate text in quotes, and without wildcards or other search constraining syntax, Jira is trying to find matches for that text as a stand alone word. It uses stemming to try to also find variations of that word. However, if the text is part of a longer unrelated word, then the search will not recognize the match. 

In your case where you are searching for "2023" which is part of the longer string "2023-05-dd" there is no match because your search is trying to find "2023" as a stand alone "word". To search for "2023" as part of a longer "word" you need to add the wildcard after it; "2023*"