JQL Issue

[Dan Billingham]

Hi,

I am trying to create a swimlane that will capture any issue that either has no component or does not have one of the following components ("Business Services", "Credit Risk", "F&E", "P&C", "P&E") but may have others.

I am building the following and all is going well:
project = "CC - Squad Demand" AND issuetype = Engagement AND component is EMPTY

When I then add the pat about not containing other components I start to not get the results I need (2000 + results):
project = "CC - Squad Demand" AND issuetype = Engagement AND component is EMPTY OR component not in ("Business Services", "Credit Risk", "F&E", "P&C", "P&E")

Have tried a few variations (using AND component not in) and also tried putting each part in different orders but nothing seems to be working. Any help would be appreciated.

Hope this makes sense, any questions let me know.

[Rilwan Ahmed · Accepted solution]

Hi @Dan Billingham 

There are missing brackets. Use this JQL

project = "CC - Squad Demand" AND issuetype = Engagement AND (component is EMPTY OR component not in ("Business Services", "Credit Risk", "F&E", "P&C", "P&E"))

[Dan Billingham]

Thanks Rilwan, 

I have discovered that the initial board filter was not correct so using your advice around the brackets have fixed it and using your answer have now sorted the swimlane. Thanks!

[Mark Segall]

Hi @Dan Billingham - You shouldn't need the component is EMPTY.  That combined with the NOT IN is going to cancel each other out.  Try this:

project = "CC - Squad Demand" AND issuetype = Engagement AND component not in ("Business Services", "Credit Risk", "F&E", "P&C", "P&E")

[Dan Billingham]

Thanks Mark : )