"Blockers" Issue links

Question

How can I query out issues that have blockers and also potentially the issues that are linked as a blocker?

thank you

Florian Bonniec · Answer

This SQL should works or close to

select CONCAT(projectsource.pkey,'-',source.issuenum) as IssueSource, issuelinktype.OUTWARD ,CONCAT(projectdestination.pkey,'-',destination.issuenum) as IssueDestination from issuelink
left join issuelinktype on issuelink.id = issuelinktype.id
left join jiraissue destination on issuelink.destination = destination.id
left join jiraissue source on issuelink.source = source.id
left join project projectdestination on projectdestination.id = destination.project
left join project projectsource on projectsource.id = source.project
where linkname = 'Blocks'

Mary Coakley_37feo1 · Answer

But this is all JQL-I'm looking for SQL.

Florian Bonniec · Answer

Hi

You cannot do it with JIRA vanilla, you are limited to only query issue linked to a specific issue using linkedIssues().

https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-functions-reference-939938746.html#Advancedsearchingfunctionsreference-linkedIssueslinkedIssues()

But you can do it with 3rd party app such as Scriptrunner.

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

I'm not familliar with JQL Trciks but this app may also do what you want.

https://www.j-tricks.com/jqlt-links-functions.html