JQL Query for summary

[Matthias]

Hi all,

I have an issue with summary "Test DA".

JQL Query "summary ~ Test" finds my issue.

JQL Query "summary ~ DA" does not find my issue.

What happens here? How can I find all issues with the String "DA" in the summary?

Thanks for your help,
Matthias

[Bill Sheboy · Accepted solution]

Hi @Matthias 

Even though not listed in the documentation for the advanced search functions, it appears that the contains (~) for text field doesn't always match.  

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/

Try adding a wildcard character to see if that helps:  summary ~ "DA*"

Best regards,

Bill

[Matthias]

Thanks for your hint.

• summary ~ "DA*" does not help
• But summary ~ \"DA\" does the expected search

I really would like to understand why summary ~ DA does not work ...

[Bill Sheboy]

I am glad you got that to work!

Yes, I am also puzzled by it not working as-is.  I have had other 2-character long searches find matches, so it is not length-related, and "DA" does not appear to be a reserved word/operator.  Very curious...

There appears to be quite a bit about JQL which is undocumented.  Often I run into errors indicating something is invalid or a reserved word requiring quotes for matches.  I hypothesize there is something in the parsing of JQL to the underlying query language for the database that it does not like.

[Matthias]

Very strange: in a fresh install with only one issue with the summary "Test DA" the search "summary ~ DA" gets the correct result ...

Ticket at atlassian is open. 

[Bill Sheboy]

Thanks!  Please post back here what you learn from Atlassian so we can all understand this better.

[Matthias]

You can find the issue for Jira here:

https://jira.atlassian.com/browse/JRASERVER-71393

[Bill Sheboy]

Hi @Matthias , and thank you for the update.

__Bill

[Erin Liva]

Using a ? after the word worked for me. The * and the escape \ did not.