JQL query to find a linked issue in another project

Question

I am looking for the Jira JQL syntax to find issues that have a linked issue in another project. For example in three projects I can find the list of issues that have been resolved in the last 90 days. I would like to find a list of issues in our QA project for the original issues resolved list.

Answer 1

sqluser was close. You don't to have designate a single issuekey, if you use the scriptrunner addon. I don't think there is a way around having it. Up to a recent version it was free so you can simply download that version. It's a must have plugin imho. Here is your query:

issueFunction in linkedIssuesOf('resolutiondate > 2015-10-01') and project = QA

You can extend the criteria of the search. Here is the documentation.

Answer 2

Try this plugin:

http://www.j-tricks.com/jql-tricks-plugin.html

specifically JQL function

linkedIssuesInProject(project,[linkType])

but the plugin is not free.

Answer 3

You can use linkedIssues function and combine it with project name

Something like this:

issue in linkedIssues(XYZ-000) AND project = 'ABC'