nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Find metric of word frequency in description

Bud Herz_4dzuwt

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

Accepted answers

Bill Sheboy

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

All comments

Bill Sheboy

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\""

Kind regards,
Bill

Bud Herz_4dzuwt

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.

Bill Sheboy

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

Bud Herz_4dzuwt

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.

Bud Herz_4dzuwt

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

description

metric

syntax