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 to find issues that don't have links of a specific type

Kelly Arrey

We've defined a Link Type called "contains <-> belongs to" so that we could build an issue hierarchy where Initiatives "contain" Features, and Features "belong to" Initiatives. I want to query for all Features that don't belong to an Initiative. What I would like to write is something like:

type = Feature AND (issueLinkType != "belongs to" OR issueLink is EMPTY)

but that's not valid JQL.

Any thoughts? What am I missing? Is there a Marketplace app that will support these semantics (not necessarily this syntax)? Thanks for any ideas you can offer.

Accepted answers

John Funk

Hi Kelly,

Try this: type = Feature AND (issueLinkType != "belongs to" OR issueLinkType is empty)

Dave Bosman _Inetum_

Hi @Kelly Arrey

First of all you should always get an error that says what you are doing wrong.

Out of the top of my head i would think the query you are looking for is

type = Feature AND (issueLinkType != "belongs to" OR issueLinkType = EMPTY)

Regards

Dave

Kelly Arrey

Update: The reason I couldn't get this work is because of JRACLOUD-73640.

Fortunately, there is a workaround:

define the following filter: `issueLinkType = "belongs to"`
I saved it under the name `has belongs to link`

Then, the filter I was originally trying to write can be expressed as:

type = Feature AND (filter != "has belongs to link" OR issueLink is EMPTY)

All comments

John Funk

Hi Kelly,

Try this: type = Feature AND (issueLinkType != "belongs to" OR issueLinkType is empty)

Dave Bosman _Inetum_

Hi @Kelly Arrey

First of all you should always get an error that says what you are doing wrong.

Out of the top of my head i would think the query you are looking for is

type = Feature AND (issueLinkType != "belongs to" OR issueLinkType = EMPTY)

Regards

Dave

Kelly Arrey

Doh! Thanks John.

Interestingly, the documentation says the IS operator is not supported for issueLinkType. That'll teach me to believe the docs :-(

Kelly Arrey

Thanks Dave.

Dave Bosman _Inetum_

@Kelly Arrey

For server and datacenter it really is not supported. That is why i used '=' in my reply.

Kelly Arrey

Good one! Thanks again.

Kelly Arrey

Update: The reason I couldn't get this work is because of JRACLOUD-73640.

Fortunately, there is a workaround:

define the following filter: `issueLinkType = "belongs to"`
I saved it under the name `has belongs to link`

Then, the filter I was originally trying to write can be expressed as:

type = Feature AND (filter != "has belongs to link" OR issueLink is EMPTY)

Welcome!

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

Quick Links

Unanswered
Groups
Help

Find more posts tagged with

cloud

jira-software

jira-software-cloud