Find epics linked to initiatives with other epics tagged with specific labels

[Scott Federman]

We have multiple epics across many different projects and some of those epics contain specific labels and are linked to initiatives using the parent link. I have a team with a specific project (QENG) that links to those same initiatives but does not use the label the other epics do.

How would i see those QENG epics that are attached to initiatives in a totally different project that have epics from other projects, linked to them where those epics use a specific label?

[Trudy Claspill]

Hello @Scott Federman 

That would not be possible with native JQL functionality.

You can find documentation of the native JQL functionality here:

https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-939938733.html

It would be possible with some third party apps that could be added to your instance. Would you consider purchasing a third party app to meet your requirement?

[Scott Federman]

@Trudy Claspill yes we would possibly.

[Trudy Claspill]

I think I need a more detailed explanation of this:

How would i see those QENG epics that are attached to initiatives in a totally different project that have epics from other projects, linked to them where those epics use a specific label?

I understand you want Epics from the QENG product, which are linked to Initiatives that are stored in (one, or more?) other projects.

I'm unclear how the Epics with Labels, which are linked to the same Initiatives but may be in yet other projects (not QENG), factor into this.

Can you illustrate your need with some example data?

[Scott Federman]

I appreciate you putting the time in on this one @Trudy Claspill .

Initiative: MGPP-1257 Identify new data network solution

Epic 1: STAYPMS-1366 AWS Provisioning (Label=steelthread)

Epic 2: QENG-907 End to end environment testing

Scenario: Both epics are linked to the same initiative. One of the epics (STAYPMS-1366) contains the label "steelthread". QENG-907 is my epic. I want to identify the STAYPMS epic attached to the initiative because it contains the "Steelthread" label.

[Trudy Claspill]

So you are trying to get a list of the Epics that have the label "steelthread", is that correct?

How does the existence of the QENG Epic and the Initiative impact what you want to extract?

I feel like I'm not quite getting your requirement. Is this statement closer? 

 "I have Epic QENG-907 and what I want is all the Epics with Labels 'steelthread' which are children of the same Initiative as QENG-907"

[Scott Federman]

@Trudy Claspill i think thats spot on.

[Trudy Claspill]

I'm sure multiple JQL-extending apps provide similar functionality. This example is from Adaptavist ScriptRunner using the portfolioChildrenOf() function.

I don't have an environment where I can actually test this, so I am theorizing that this will work. I don't actually know if the functions can be nested this way.

Use this to get the parent of QENG-907

issue in portfolioParentsOf("issue=QENG-907") and issuetype=Initiative

If you need to derive the QENG Epics dynamically you can insert the selection criteria or a saved filter as the input for the portfolioParentsOf function.

issue in portfolioParentsOf("filter='saved filter name' ") and issuetype=Initiative

or

issue in portfolioParentsOf("project=QENG and issuetype=Epic") and issuetype=Initiative

Save the above as a Filter.

Use it thus. 

issue in portfolioChildrenOf("filter = 'QENG parent filter' ") and 
issuetype=Epic and Labels in ("steelthread")

This will get you the children of the Initiatives that you got in the first filter, further filter those results to get only Epics with the specified Label.