JQL results not just Epics Linked to Parent Issue- also include the Epic Parent's linked Parent

Terri Booker_hlcsdz

We are not using Portfolio - we have Link type Options we use "Is ParentIssue of" and "Is ChildIssue of" > created by our Core Team" that we are to use.

Scenario: I am trying to write a JQL that will pull all the Features (Initiative) with all Linked  Epics . Epics linked from Feature(Initiative) with link type= "Is ParentIssue of" using the below JQL - it's works however it's also pulling the Feature's (Initiative) Parent the Capability (Purpose) since linked from the Capability with link type= "Is ParentIssue of". 

How can I Exclude anything other than the Linked EPICS that the Feature(Initiative) is the Epic's "Is ParentIssue of"...

project = XYZ AND issuetype = FEATURE AND issueLinkType in ("is ParentIssue of") ORDER BY issuetype ASC, created DESC

I tried so many variations - and still have the  Capability being invluded in the query results since it's linked with the "Is ParentIssue of" for the Feature(Initiative).

Also Tried below: I am sure there's a way to do this - but I gave up, and am hoping for some suggestions... 

project = XYZ AND issuetype = FEATURE AND issueLinkType in ("is ParentIssue of") AND issueLinkType in ("is ParentIssue of") AND issuetype !=Capability ORDER BY issuetype ASC, created DESC

project = XYZ AND Issuetype = Feature AND issueFunction in linkedIssuesOf("Issuetype = Epic") ORDER BY issuetype ASC, created DESC

project = XYZ AND Issuetype = Feature AND issueFunction in linkedIssuesOf("Issuetype = Epic") AND project = XYZ AND issueFunction in linkedIssuesOf("Issuetype != Capability")ORDER BY issuetype ASC, created DESC

Dan Tombs

Hi @Terri Booker While I cannot say for certain right now you may want to look at the issue link type name. When using the JQL for linked issues you can either search for the whole link type of the specific inward or outward link type. While I doubt it you may be searching the name of the link type rather then the direction?

 

The other thing you may be able to consider is the use of something like JQL Extensions app or Enhanced Search marketplace apps to extend and help with any JQL issues. JQL extensions has more enhanced parent and child issue searching that can provide a better understanding up and down the hierarchy.