JQL query for search issues based on substring as wildcard * can’t be used as first character

Question

Ex: ABCD123

I want to search Issues using advanced search where issue summary contains 123 but due to restricted characters as per information here https://confluence.atlassian.com/jirasoftwareserver0710/advanced-searching-953146961.html and wildcard * can’t be used as first character.

1) summary ~ "123" --> Doesn't return any result as it is substring.

2) I am able to query JQL using "ABCD*" using wildcard operator and getting result.

3) "*123" doesn't return any result

Is there any workaround for this ?

Dirk Ronsmans · Answer

Apologies, missed that one.

Seems prefix searching is just not supported yet however they should support it from Server 8.6.0 on.

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

What server version are you on?

Prasad Pendke_51881d · Answer

1) summary ~ "123" --> Doesn't return any result as it is substring.

2) I am able to query JQL using "ABCD*" using wildcard operator and getting result.

3) "*123" doesn't return any result

Dirk Ronsmans · Answer

Hi @Prasad Pendke ,

Wouldn't a simple JQL like:

summary ~ "123"

already work?

the tilde operator ~ is a contains operator so that will also look for substrings.

https://confluence.atlassian.com/jiracoreserver073/advanced-searching-operators-reference-861257221.html#Advancedsearching-operatorsreference-CONTAINS