How to find a Jira by a keyword in Summary field? Thanks!

This question is in reference to Atlassian Documentation: Advanced searching - keywords reference

Ladies and Gentlemen,

Could you please help check how to find a Jira by a keyword in Summary field? The keyword is not at the beginning position of Summary, so the following searching criteria doesn't work:

Summary ~ "*translation"


Many Thanks in advance.


Best Regards

Na Liu

2 answers

Many Thanks Vasiliy for your help to check this! Really appreciated.

Sorry I didn't put the question clear just now. The searching criteria which didn't work is as below:

Summary ~ "*translation"

from the doucment: You cannot use a * or ? symbol as the first character of a search. 

I've updated the original question too. Because the keyword "translation" is not at the beginning position. Any idea?

Best Regards

Na Liu

Oh, this is sad, but it is not possible in JIRA:

I use SQL to get such information. Here is for MS SQL 

Select	project.pkey + '-' + CAST(jiraissue.issuenum as varchar(20))
		, jiraissue.SUMMARY
from	jiraissue
		join project	on jiraissue.PROJECT = project.ID
where	jiraissue.SUMMARY like '%test%'

Many Thanks Vasiliy for your help checked this and your SQL! A good practice for a DB admin of JIRA DB. :-D

0 vote
Sam Hall Community Champion Nov 24, 2016

Hi Na Liu,

Are you sure simply searching without any "*" doesn't give you what you want? When I do a similar search, it shows me issues where "translation" is anywhere in the summary. Like this:


Is this not what you want?

Or do you want to exclude issues starting with "translation" from your results?


Hi Sam,

Many Thanks for help checked this. "*" do give all the Jiras or I could filter to all issues under my name. Problem is there is a lot...a lot Jiras under my name, I'd prefer to get all issues which relate to "translation" only at one stroke. Then comes this question here. : -)


Best Regards

Na Liu

Suggest an answer

Log in or Join to answer
Community showcase
Louis De Jaeger
Posted Thursday in Off-topic

Friday fun: your best joke

Hi all Lets make this Friday fun really fun and post one (or more) of your best jokes! The joke can be about an Atlassian product, or just a really fun joke you want to share! I’m not the best j...

189 views 12 3
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot