JQL to find the issues in one project not linked to another project.

[neelam annad]

Need a JQL to find the issues in one project not linked to another project.

For example - I have Epics in one project and Capabilities in other project, want to know the Epics which are not linked to Capabilities using "is related to"

[Andrea Pannitti · Accepted solution]

Hi @neelam annad ,

if you have ScriptRunner, you could use a JQL like the following:

project = First_Project and type = Epic and not issueFunction in linkedIssuesOf("project = Second_Project and type = Capabilities", "is related to")

Where First_Project is the project with Epic issuetype and Second_Project is the project with Capabilities issuetype.

[S Fong]

What happens if I don't have ScriptRunner?