Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Question about a query

jeff trotman January 22, 2020

SO, this is the overview, we recently migrated a lot of data from another JIRA system in a new JIRA and all the old bugs had the label MDO-bug put in, all new bus do not have the label, in the old system because of the way it was run, would have bugs come in and if they were not considered a bug, but an Enhancement the severity would be changed to Enhancement.

 

My query is :

project = "blah" AND "Escalation Group" = "blah de blah" AND (labels = MDO-Bug OR (severity in (Catastrophic,Severe, Moderate, Minor) or Severity is EMPTY))

Now can anyone tell me why I am still getting Severity = Enhancement bug returning with this query, I'm guess because labels = MDO-Bug, if i put an AND statement so:

 

project = "blah" AND "Escalation Group" = "blah de blah" AND (labels = MDO-Bug AND (severity in (Catastrophic,Severe, Moderate, Minor) or Severity is EMPTY))

It removes all the bugs which do not have the label i.e the newly raised bugs 

 

Thanks,

Jeff

2 answers

2 accepted

0 votes
Answer accepted
SITTER Adrien
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 22, 2020

Hello Jeff,

 

You are wright it is because of the OR:

labels = MDO-Bug OR ANYTHING

 

If an issue has the label MDO-Bug, it is selected, we don't even have to look at what is after the OR.

If you want all MDO-Bug but with severety not Enhancement and new bugs with any severity you need something like this:

project = "Software Development Inbound" AND "Escalation Group" = "SDI - App - iOS" AND ((labels = MDO-Bug AND Severity != Enhancement) OR (labels != MDO-Bug AND SOMETHING_FOR_NEW_BUG))

 You can may be replace SOMETHING_FOR_NEW_BUG by issueType = Bug.
It depends of your configuration.

 

Hope it helps,

 

Adrien

jeff trotman January 22, 2020

Yep, cheers Adrien

0 votes
Answer accepted
jeff trotman January 22, 2020

I realised that i didn't need the label and could do the search by using the following:

("Request Source" in ("SNOW ProblemTask", Other) AND Severity in (Catastrophic, Minor, Moderate, Severe) OR Severity is EMPTY)

Solved the headache i'd been having

Suggest an answer

Log in or Sign up to answer