Question about a query Edited

[jeff trotman]

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

[jeff trotman · Accepted solution]

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

[SITTER_Adrien · Accepted solution]

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]

Yep, cheers Adrien