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

[Prasad Pendke]

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]

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

[Prasad Pendke]

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]

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?