JQL text search with "IT"

[Janakiraman S]

Hi Team,

We have country codes / locale defined in a Text field. I could find few results when I use "country ~ EN", "country ~ ES", "country ~ FR" etc... 

But when I simply lookup "country ~ IT", I don't get any results although there are records with country code IT. 

Is "IT" a jira keyword? Atleast could not find it JQL Keywords 

Has any of you encountered this?

Thanks & Regards,

Janaki.

Honestly quite disappointed with this behavior of JIRA as the search with country is pretty important for us. 

[Jack Brickey · Accepted solution]

Yes "it" is a reserved text search string. Please refer to this document - search-syntax-for-text-fields 

here is the pertinent excerpt...

Reserved words

To keep the search index size and search performance optimal in Jira, the following English reserved words (also known as 'stop words') are ignored from the search index and hence, Jira's text search features:

"a", "and", "are", "as", "at", "be", "but", "by", "for", "if", "in", "into", "is", "it", "no", "not", "of", "on", "or", "such", "that", "the", "their", "then", "there", "these", "they", "this", "to", "was", "will", "with"

[Daniel Turczanski - JQL Search Extensions]

Hi @Janakiraman S ,

Standard JQL doesn't easily allow searching for exact words, special phrases and patterns.

You may use our professional indexing service JQL Search Extensions

After you install the app you can simply search:

issue in wildcardMatch("country", "IT")

Check out the docs for more information.

I hope this helps!
Daniel