A JQL filter which queries a short text custom field provides inconsistent results

Question

I am having quite a confusing experience. One of my filters does not work as expected: it yields different results for similarly identical queries. The part of the query which is incosistent is around a custom short test field.

Given that I have 5 tickets with "Issue ID" set to "[UNKNOWN] License BeOpen app/env/lib/python3.11/site-packages/typing_extensions-4.12.1.dist-info/LICENSE", I have different results for different queries:

* "Issue ID[Short text]" ~ "\[UNKNOWN\[ License BeOpen app/env/lib/python3.11/site-packages/typing_extensions-4.12.1.dist-i": finds nothing
* "Issue ID[Short text]" ~ "\[UNKNOWN\[ License BeOpen app/env/lib/python3.11/site-packages/typing_extensions-4.12.1.dist-in": finds all 5 tickets
* "Issue ID[Short text]" ~ "\[UNKNOWN\[ License BeOpen app/env/lib/python3.11/site-packages/typing_extensions-4.12.1.dist-inf": finds nothing

* "Issue ID[Short text]" ~ "\[UNKNOWN\[ License BeOpen app/env/lib/python3.11/site-packages/typing_extensions-4.12.1.dist-info": finds all 5 tickets

* "Issue ID[Short text]" ~ "\[UNKNOWN\[ License BeOpen app/env/lib/python3.11/site-packages/typing_extensions-4.12.1.dist-info/": finds all 5 tickets

* "Issue ID[Short text]" ~ "\[UNKNOWN\[ License BeOpen app/env/lib/python3.11/site-packages/typing_extensions-4.12.1.dist-info/L": finds nothing

Expected result is that all these queries should return the same listing, because all listed conditions are true for all of my tickets.

Hannes Obweger - JXL for Jira · Answer

Hi @Anatolii Stehnii

welcome to the community.

I would assume that this is related to how Jira does its internal indexing for full-text search, in particular wrt. special characters. This article gives some insights on the matter.

If you are open to solutions from the Atlassian Marketplace, there are ways to overcome JQL's text filtering limitations. Happy to elaborate if this is something that might be of interest to you.

Best,

Hannes