JIRA Inter-Projects dependency report

[Janakiraman S]

Hi Team,

I am looking to get a report of Interproject dependencies on Epics/Initiatives. That said a list of Epics that are linked to Epics/Initiatives in other projects. I am trying to run a JQL like

project = A and type = Epic and hasLinkType(“Blockers“) and issueFunction not in linkedIssuesOf(“project = A“).

This gives me a result closer to our requirement. However, our Initiatives are mapped to Team A (JIRA single select custom field). We want to exclude the Epics that are linked to Initiatives of Team A from the result set. Is there a way to achieve this using the issueFunction?

Something like

project = A and type = Epic and hasLinkType(“Blockers“) and issueFunction not in linkedIssuesOf(“project = A“) and issueFunction not in linkedIssuesOf(“project=INIT and team=Team A)“)

Unfortunately, when I try this, I don’t get any results although I have 1 Epic that is linked to an Initiative of Team B with Blocker type.

Any ideas how to accomplish this using JQLs? 

Thanks & Regards,

Janaki.

[Humashankar VJ]

Hello

While we try to exclude Epics linked to Initiatives of Project A
Try with IssueFunction linkedIssuesOf
However JQL wont support for custom field values of linked issues

Try find the Initiatives of Project A
then find the Epics linked to those Initiatives and exclude them from the final outcome.