JQL query to find out numbers within summary field

Question

Hi,

All my summary fields for issue type testcases start with [TC-01-UN-1234] , [TC-02-UN-1234] , [TC-01-UN-4567, etc...

I want to search all testcases which are part of perticular UN.  I am trying following JQL but it doent return the expected result:

summary ~ "UN-1234"  return nothing  but If try:

summary ~ "UN-" i get everything.

Can someone help me with this issue.

Thanks

Mangesh

JamieA · Answer

It's not straightforward, if you have script runner you can use:

issueFunction in issueFieldMatch("project = JRA" , "summary", "UN-\d*")

See https://jamieechlin.atlassian.net/wiki/display/GRV/Scripted+JQL+Functions#ScriptedJQLFunctions-issueFieldMatch(subquery,fieldname,regexp)

Mangesh Rane · Answer

No, it didnt work.

Udo Brand · Answer

Hmm,  "-" is special character you might want to escape. Maybe it works

summary ~ "UN\-1234"

please see here: https://confluence.atlassian.com/display/JIRA/Performing+Text+Searches#PerformingTextSearches-Escapingspecialcharacters:\or\