Expression for linked issues in two different projects

[sschlinge]

I am looking for a Jira Query , which helps me with a specific problem. We are having one main issue (user Story) in one project , which is linked to other issues in another project. All linked issues are in the other project.

Does anyone know how to solve this in a list and which query do I use? 

Thanks a lot !

[Mikael Sandberg · Accepted solution]

Hi @sschlinge,

Welcome to Atlassian Community!

You can use the linkedissue function to get them, like this:

issue in linkedIssues("JRA-123")

Please note that you cannot get both the user story and the linked issues in one JQL, in order to do that you would need an app for it, like JQL Search Extensions for Jira & reports,Enhanced Search (JQL & Subqueries) or Scriptrunner. 

[Sramanth Pandeti · Accepted solution]

Hi @sschlinge If you're looking to find the linked issues for that one main issue (user story), then you can use this below query:

issue in linkedIssues("Issue key of the user story")

E.g. issue in linkedIssues("ABC-1")

[sschlinge]

Hi all, thank you very much, I just found an answer myself, I was just not able to find an expression for searching in two projects , I have always tried AND or OR , but I just need to use project in (ProjectA, ProjectB).... This was just too simple :-)

[Martin Bayer _MoroSystems_ s_r_o__]

hi @sschlinge I'm not able what should be returned? The linked issues of the issue you know or all the issues (main issue + linked issues)?

[sschlinge]

Hi Martin, it should return the linked issues and the main issues if possible. But these are in different projects.