Searching terms with multiple hyphens

[t_s_llc]

I am looking at Jira Service Management Cloud for my environment and I just discovered that there is a long known issue in Jira searching for terms with hyphens in them. This is a huge issue for me because our asset naming scheme includes lots of hyphens.

I might have an asset named NY-BDG1-ABC12. The only search term that matches this for me is "NY BDG1" with a space. Not "NY-BDG1-ABC12", not "NY-BDG1", not "NY\\-BDG1\\-ABC12", not "*ABC12", not "ABC12", not "NY?BDG1?ABC12". The only problem with that is I have too many other assets that start with "NY-BDG1" to make this practical. I need to search the whole asset name or at the very least, search the end of the asset name (ABC12).

Does anyone here have experience working around this limitation or know of a search technique or JQL query that will work?

[Joseph Chung Yin · Accepted solution]

@t_s_llc -

What is the data type for your asset field?  If it is a text field, the please take a look at this documentation page https://confluence.atlassian.com/jiracoreserver0814/search-syntax-for-text-fields-1043894982.html  (Focus on the section - "Special Characters" and "Exact searches (phrases)" section.

Even though it is for Jira DC env and not for CLOUD env, but the JQL search behavior are the same.

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

[t_s_llc]

Ah ha. I had already looked at that page but my jql syntax was off. I needed to escape my double quotes in an advanced search:

Text ~ \"NY-BDG1-ABC12\" order by created DESC

Hopefully this helps someone else. I'd seen the hyphen search problem elsewhere but no solutions.

[Sharath Nandi Ramachandra]

we use JIRA Service Management, recently migrated this to cloud.

escaping double quotes does not work for us.

this particular text "00-ABCD00" exists in 4 different tickets but only 1 returns from JQL query.

Quick search returns the other 3 tickets. Not sure how to resolve this.

Also this link does not work anymore

https://confluence.atlassian.com/jiracoreserver0814/search-syntax-for-text-fields-1043894982.html 

[Becky]

The valid link is now: https://confluence.atlassian.com/jiracoreserver0814/search-syntax-for-text-fields-1043894982.html