Can I used JQL to find open tickets that are dependent on other open tickets?

Question

I manage a department with several Jira projects and issues in my projects are often dependent upon issues in other projects managed by other departments.

I am trying to construct a query that will return my open tickets that are dependent upon open tickets in other departments projects.

Jack Brickey · Answer

what defines "dependent" are these links? There isn't a good way OOTB to assess if an issue has links using JQL. Scriptrunner (issuehaslinks) and other addons can help with that. you could consider automation to set a custom field (haslinks) whenever a link is added which could then be worked into your JQL. But nothing OOTB AFAIK.

Andrew Laden · Answer

Start with the JQL functions LinkedIsssues() and issuesWithRemoteLinksByGlobalId()

the AM Utils add on adds a JQL function. "LinkedIssueHadsStatuses" that may help

https://confluence.cprime.io/display/CADS/AMU+-+Using+JQL+functions