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

Vasiliy Zverev Community Champion Nov 24, 2016

Oh, this is sad, but it is not possible in JIRA: https://jira.atlassian.com/browse/JRA-6218?_ga=1.36909667.2119377251.1478066480

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:

issue-search-keyword.jpg

Is this not what you want?

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

Sam

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 Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted yesterday in Confluence

Calling all marketing teams who use Confluence - we want to hear from you!

Hi Community! me again 🙂 If you’re a marketing team using Confluence, we want to hear your story! How did you start using Confluence? What are your use cases? What have been some of the benefits?...

46 views 1 2
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