Inconsistent search results when using dashes.
Platform Notice: Cloud and Data Center - This article applies equally to both cloud and data center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Problem
When using dashes "-" in text-field custom fields you receive inconsistent search results in JQL.
Diagnosis
Diagnostic Steps
Create text-field custom fields with values of test-123 test-456 test-789
Search for "<customfield>" ~ test-*"
After a re-index, you may or may not get all of those expected values from the query result
Cause
Lucene indexing doesn't index dashes, so using them in your text fields will result in inconsistent results when attempting to query them. Especially when combined with the "*" operator.
See JRASERVER-45286 - Inconsistent behavior with contains Dash operator (-) and the response that this is not a bug.
Solution
Workaround
Replace underscores (or don't use either) for dashes for any value that you are going to be consistently searching against.
Was this helpful?