How can i show the outward and inward descriptions for a linked issues within search

Question

I want to produce an extract of linked issues, and want to show the inward/outward description related to each issue - is there a way to accomplish this?

Pamela Little · Answer

Thanks Marcus.

As I'm new (relatively) to using JIRA for informational reporting within confluence,  you would execute this SQL via a scripting tool ?

Tx, Pam

Marcus Silveira · Answer

We could get this directly from Jira's DB with something like the following

select concat(PS.pkey,'-',S.issuenum),ILT.outward,concat(PD.pkey,'-',D.issuenum) from issuelink IL
join issuelinktype ILT on ILT.id = IL.linktype
join jiraissue S on S.id = IL.source
join jiraissue D on D.id = IL.destination
join project PS on PS.id = S.project
join project PD on PD.id = S.project