Scriptrunner - List Issues With Links To Other Projects

[Marc Moroz]

Hi,

I'm trying to use ScriptRunner to identify all non-Done issues with links to non-Done issues in external projects.  So far, I have this.

issueFunction in hasLinks() AND statusCategory != Done

I can't find how to limit results only to links going to other projects and only to non-Done issues.

Bonus Points:

When showing the results on a Jira dashboard or Confluence, how would I show the project of the external issue?

[Roland Holban (Adaptavist) · Accepted solution]

You could do something like this where PROJECT_NAME is the project name of the project you dont want.

issueFunction IN linkedIssuesOf("statusCategory != Done AND project != PROJECT_NAME") AND statusCategory != Done

[Marc Moroz]

Thanks.  This is essentially where I landed:

project = "myProject" and issueFunction IN linkedIssuesOf("statusCategory != Done AND project != myProject") AND statusCategory != Done

This will show me everything in myProject with links outside of myProject.

Jira has a Links column which shows the key but that's not very helpful without the linked project and linked summary.