Find all link issues

Question

I'm trying to find all the issues in project 1 in the active sprint and link issues from the sprint in project 1, but they are in other projects.

I was only able to make such a request, but it displays all issues without exception that are related to project 1

project = 1 OR (project in (2,3,4,5,6) AND issueFunction IN linkedIssuesOf(' project = 1')) ORDER BY Rank ASC

Nic Brough -Adaptavist- · Answer

Welcome to the Atlassian Community!

I am not 100% sure that I understand "and link issues from the sprint".  Do you mean "all issues in projects 2-6 that are linked to issues in project 1's current sprint?

If so, then the problem is the first clause, and sub-clause - "project = 1" is selecting all issues in project 1, both selecting too much.

I think you probably want

(project = 1 and sprint in OpenSprints() ) OR (project in (2,3,4,5,6) AND issueFunction IN linkedIssuesOf(' project = 1 and sprint in OpenSprints() ')) ORDER BY Rank ASC

umer_saeed · Answer

Not sure I understand what you're looking for.

Do you want only the results to show issues that are in the current active sprint inside Project 1, which have links to issues from other sprints?