How to find Parent Child relationship between two JIRA issues in DB?
I checked issuelink table. It has source and destination column. But how to know which one is parent whether source or destination?
Issuelinktype stored inward and outward values. But where do we store whether the relationship between two issues is inward or outward?
First, write your SQL and execute. Don't worry about the source/ destination directions. Put whatever the direction you assume to be correct.
Compare the SQL result against an issue viewed in the web browser. If your SQL result is correct, then you're done. Otherwise, swap between source and destination.
You don't have to worry about inward/ outward terms.
select i2.pkey issue, i1.pkey parent from jiraissue i1, jiraissue i2, issuelink l, issuelinktype lt where i1.id = l.source and i2.id = l.destination and l.linktype = lt.id and lt.linkname = 'Cloners';
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot