JQL to get list of stories in openSprint with list of their dependencies

[jodywhite]

Is there a JQL that's able to get a list of stories in an openSprint (I do know how to get this list) but I also want a list of linked issues for "is dependent on".

Is this possible using JQL?

Thanks!

[Earl McCutcheon]

Hello @jodywhite ,

The Dependencies are based on issue links and the natively available JQL for issue links is going to be either of the following referencing Advanced search reference - JQL fields:

issue in linkedIssues(issueKey)

or

issue in linkedIssues(issueKey,linkType)

Noting that the values are relying on the source issue to define an individual issue to reference a source, but there is not a method to pass in multiple issues, and we have a feature request tracking interest in this at the following link.  Make sure to add your vote to the request:

• https://jira.atlassian.com/browse/JRACLOUD-22577

There is an option to accomplish this using SQL for Jira in this comment however that only applies to Jira Server or Datacenter versions, since you are on cloud an option to get around this would be to look at the third party plugin ScriptRunner for Jira  which has scripted JQL functions that can isolate for link types,  some details can be seen on their documentation pages here:

• https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_issue_links

And some additional recommendations on using this function provided by ScriptRunner in the following Community posts where other users were looking for a similar action and this tool was the recommended solution:

• https://community.atlassian.com/t5/Jira-Core-questions/How-do-I-filter-issues-that-are-blocked-in-JQL/qaq-p/1179311
• https://community.atlassian.com/t5/Jira-questions/Filter-Issues-that-are-Open-Blocking-OR-Blocked-by-Open-Issues/qaq-p/693758
• https://community.atlassian.com/t5/Jira-questions/Get-list-of-linked-issues-how-to/qaq-p/95753
• https://community.atlassian.com/t5/Jira-questions/JQL-is-it-possible-to-search-for-issue-links-created-within-a/qaq-p/352612

Hope this helps get you on the right track

Regards,
Earl

[jodywhite]

That got me close to what I'm looking for. For now my JQL is, "project = PROJECTNAME AND issueLinkType = "is dependent on" AND sprint in openSprints() AND labels = LABEL_NAME"

That gives me a list of items in the sprint that has the issueLinkType of is dependent on, I used that for a board query, then I edited the card to show the Linked Issues on the card.

So I have a board of issues that have dependencies on other issues.