Help needed: Swimlane JQL

[Alison Sawyer]

• Goal: create a swimlane that groups issues that are Priority 1 OR 2 excluding Epics A and B, and excluding Labels C and D.
  
  
• Problem:  the swimlane shows all Priority 1 issues but not any Priority 2 issues
  
  
• JQL I've tried:
  •  priority = "1" OR priority = "2" AND ("Epic Link" != "A" OR "Epic Link" != "B") AND (labels != "C" OR labels!="D")
  • (priority = "1" OR priority = "2") AND ("Epic Link" != "A" OR "Epic Link" != "B") AND (labels != "C" OR labels!="D")
  • with priority in quotes
  • with no quotes around the numbers 1 & 2 (swimlane disappears altogether)

Maybe someone can help me fix my jql so it works? Thanks in advance.

[Harald Seyr · Accepted solution]

Hi @Alison Sawyer

from memory, so please excuse if not accurate: I suspect the parts "Epic Link" != "A" and labels!="D" exclude all issues where no epic link or label exists.

This is because the comparison checks "if there is a link that is not A", so if there is no link, then it does not match the condition.

Please verfiy this by using something like "(Epic Link" != "A" or "Epic Link" is empty") and "(labels != "D" or labels is empty)".

In any case, you can copy the JQL to the "Show all issues" list and check the actual result there.

Regards,

Harald

[Laurie Sciutti]

Try:

priority in ("1", "2")…

[Trudy Claspill]

Are you using the built in Priority field or a custom priority field? Can yo show us an example of this field in and issue with the value 1 or 2 in it?

Is this swimlane the one at the top of your Swimlanes list?

Do you have Priority 2 issues that are linked to Epics? And that also have Labels values other than "C" or "D"?

Can you show us the screen image for a Priority 2 issue that you think should be included, showing us the Epic Link field and the Labels field?