Find issues blocked by issues in another project

[Michael Pasek]

Seems like something everyone would want to do. Team A is waiting on something from Team B. Team A Project issue is blocked by issue in Team B Project.

This gets me all blocked issues...but can't figure out how to filter down to just those blocked by another team..(i.e. add an AND condition to ensure two project names are different)

(issueFunction in hasLinks("is blocked by") or issueFunction in hasLinks("blocks")) AND issuekey in (childIssuesOf(<inititiave>), childIssuesOf(<initiative>))

[Suvarna Gaikwad · Accepted solution]

@Michael Pasek This query could help. Please try and let us know if it helps you solve your problem.

project = X AND issueFunction in linkedIssuesOf("project != X","blocks")

P.S. replace X with your project key.

[Michael Pasek]

Many thanks for the prompt reply! This helped for sure.

I ended up with this (I have two initiatives under one portfolio which complicates things). I think this works. It comes up empty in my case but I think that's correct.

So this finds -- I believe -- all issues in all projects under the two initiatives except for Project A that are blocked by issues in Project A

project != "Project A" AND IssueFunction in linkedIssuesOf("project ='Project A'", blocks) AND status != Closed AND issueFunction in linkedIssuesOf("status != Closed") AND issuekey in (childIssuesOf(Initiative1), childIssuesOf(Initiative2))