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

[Pamela Little]

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?

[Marcus Silveira]

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

[Pamela Little]

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