Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Find metric of word frequency in description

Edited

Background
There are times when we have a collection of bugs in one bug ticket to expedite the dev team fixing everything related to one area.

 

Challenge
Pull metrics that report those bugs within a single ticket so our numbers might show 30 bugs vs 5 Bug tickets. 

 

EXAMPLE DESCRIPTION - 

This bug should have some varied ways to identify multiple bugs in a single ‘parent’ bug.

Bug 1 -

Bug 2

Bug three:

This sentence uses the word bug to confirm it’s excluded from the search.

 

EXAMPLE QUERY (not working) - 

project = BSP AND issuetype = Bug AND description ~ "Bug 1" AND NOT description ~ "bug" ORDER BY Key ASC

 

 

2 answers

1 accepted

0 votes
Answer accepted

Hi @Bud Herz 

I am a bit unclear what you are expecting the results of that search to be: nothing or something.  Would you please clarify?

Regarding the query you provided, the contains operator ~ can do an exact match if you escape the search in quotes, like this:

project = BSP AND issuetype = Bug AND description ~ "\"Bug 1\""

But, you are also trying apparently to exclude things which contain "bug", perhaps with !~ and so that may not work as you expect: one search string is a subset of the other due to the "fuzzy" searching for contains.

Kind regards,
Bill

Hey @Bill Sheboy 
We have plenty of bugs that may casually mention other bugs in their descriptions. Things like "...fix may still be blocked by bug BSP-2345". 

I am hoping to find results specific to the format we use when we list multiple issues in a single bug. Most often the method would be like "Bug 1" 

Now using what I thought was a specific search for "Bug 1" instead returns everything with "Bug" anywhere in the description. So what I started with was - 

project = BSP AND issuetype = Bug AND description ~ "Bug 1" ORDER BY Key ASC

For me, that does not return only "Bug 1" results. I have studied the syntax help page and swear I am doing it how it should be used, but obviously I'm missing something simple.

Thanks, Bud.  To exactly search for "Bug 1" you will need to escape the quotes like this:

project = BSP
AND issuetype = Bug
AND description ~ "\"Bug 1\""
ORDER BY Key ASC

Thanks @Bill Sheboy , but unfortunately that still returns everything where the word bug shows in a description. I've tried to play with that to figure out if you had a typo, but I haven't had any luck yet. 

I just re-tried it and it worked for me.  Perhaps try checking your field setup to see if the type / editor has been changed, as that might impact the contains operator.  Otherwise I'd check with support as that should work for Jira Cloud.

Like Bud Herz likes this

Bill seems to have the correct answer, but it looks like a setup problem in my Jira needs investigating. 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
Community showcase
Published in Jira

Do you use Jira Cloud with Microsoft Teams?

Hi, Jira users! Do you use Jira alongside Microsoft Teams? We want to hear how you’ve used the power of Jira Cloud and Microsoft Teams (via the Jira Cloud for Microsoft Teams app) to achieve a team...

238 views 1 5
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you