Filter Query for related projects in JIRA

[aman agarwal]

i require to create a query to where in i need to search all issues reported in 'Project A' which have a link(link type: 'relates to') with a few of the issues reported in 'Project B' (By few issues i mean that i will have a query to filter out a sub set of issues from Project B).

issuetype = Story AND status = Open AND project = "Project A" AND relation type= 'relates to' with ID in (select ID where issuetype = Story AND status = Open AND project = "ProjectB" )

I an mot being able to find a way how to link the two projects. Is this possible?

[RambanamP · Accepted solution]

you can try with jql functions(linkedIssuesInProject(project,[linkType])) in JQL Tricks Plugin

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

or try with jql functions in script runner plugin

https://jamieechlin.atlassian.net/wiki/display/GRV/Scripted+JQL+Functions#ScriptedJQLFunctions-linkedIssuesOf(Subquery,linkname)