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; } } }

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.

Accepted answers

Rilwan Ahmed

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

All comments

Rilwan Ahmed

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

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 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!

Dan Billingham

Thanks Mark : )

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud