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

Pamela Little November 9, 2017

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?

1 answer

0 votes
Marcus Silveira
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
November 10, 2017

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 November 10, 2017

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

Suggest an answer

Log in or Sign up to answer