Epics without Initiatives JQL

[Andres Dominguez]

Hi!

I'm trying to find a way to query epics that are standalone, meaning, that they are not linked to the many initiatives in my project. Right now, I use the "supports initiative" link on epics to tie them back to initiatives; so trying to come up with a query to see if any of my epics is missing that link. How do I go about doing this? 

[Pierre Leroux]

I personally use this filter to track them:
issuetype=Epic AND "Parent Link" is EMPTY

[Jack Nolddor _Sweet Bananas_]

Hi Andres,

Have you try the following using Advanced Searching?

type = Epic AND issueLinkType != "supports initiative" OR issueLinkType IS EMPTY

Regards

[Andres Dominguez]

Hi Jack, 

I got the below error when trying to query the above. Wondering if it's a Jira version (Jira v7.13.9) issue or my permissions. 

"Field 'issueLinkType' does not exist or you do not have permission to view it"

Thoughts?

[Jack Nolddor _Sweet Bananas_]

Sadly, issueLinkType was introduced on Jira 8.x

Alternatively, you can use a third-party app, i.e. JQL Booster Pack and type the following:

type = Epic AND issue NOT IN linkedIssuesOf("type = Initiative", "is supported by")

Note that you must tune the above query mostly to edit the "is supported by" link and use here the other way of your "supports initiative" link that is the description displayed on the Initiative side.

References:

• Official documentation

Hope this helps you to create awesome queries <3
Kind regards

[Andres Dominguez]

Hi Jack, 

I tried the above the link description on the initiative: 

project = fxtrade and type = Epic AND issue in linkedIssuesOf("type = Initiative","is implemented by")

But I'm now getting the below error: 

"More than one link type with description: is implemented by, this is not currently supported"

Hopefully this means we're getting closer!

[Jack Nolddor _Sweet Bananas_]

Hi Andres,

It seems more that one link type with description: is implemented by is configured in your system.

As a Jira Administrator, could you navigate to Administratio >> Issue > Issue Linking to see if more than one issue link have "is implemented by" in either inward or outward description?

Note that linkedIssuesOf() does not support duplicate linkDescriptions at this time.

Regards

[Andres Dominguez]

Thanks Jack.

I tried this path and it seems that since is managed at the enterprise level, it's tough to change in my company. And I dont want go and update a bunch of epics to new link types. I ended up doing the below and it works but just need to keep a list of initiative IDs (just 15 atm). 

project = P1 AND type = epic AND issue not in linkedIssues(initiative ID 1) AND

project = P1 AND type = epic AND issue not in linkedIssues(initiative ID 2) AND

…

project = P1 AND type = epic AND issue not in linkedIssues(initiative ID 15)