Epics without Initiatives JQL

Andres Dominguez March 4, 2020

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? 

2 answers

0 votes
Pierre Leroux
Contributor
February 3, 2023

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

0 votes
Jack Nolddor _Sweet Bananas_
Atlassian Partner
March 4, 2020

Hi Andres,

Have you try the following using Advanced Searching?

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

 

Regards

Andres Dominguez March 5, 2020

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_
Atlassian Partner
March 5, 2020

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:

 

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

Andres Dominguez March 5, 2020

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_
Atlassian Partner
March 5, 2020

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 March 12, 2020

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)

Suggest an answer

Log in or Sign up to answer