Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

jql results with capitalized field

Rafel Coyle
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 4, 2019

I want to return the results where all of the description fields contain upper case "EMV"  so the data might have been entered in upper case or lower case, but I need all records containing this sub string.

1 answer

0 votes
Tom Lister
Community Champion
January 5, 2019

Hi @Rafel Coyle

Jira uses Lucene for text searching and it is case sensitive.

You need to CONTAINS(~) operator

e.g.

Description ~ “EMV”

Rafel Coyle
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 7, 2019

My question is for the situation where the database contains upper or lower case characters and I need to convert the data field to upper case for comparison.  So if the database contains Cat or cat I want to compare to CAT and get a match.

Tom Lister
Community Champion
January 7, 2019

Hi

the Jira lucene index searching is case sensitive and there is no way around that AFAIK

but you could try

description ~ “Cat” || “cat” || “CAT”

cumbersome but should work

https://confluence.atlassian.com/jiracoreserver072/search-syntax-for-text-fields-829092675.html

Like Daniel Burris likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events