I am writing a simple query against the Jira Database, but I cannot get the parent issue id of the issues. I tried including customfieldvalue.parentkey, but it is NULL for all the subtasks. Does anyone know what the actual parent key id is?
I came across this thread because I am trying to get the Parent link directly out of jira database by querying in SQL. I am not able to find it. Could you please share your sql code that you wrote to get it. Thank you in advance.
Here is the Sql query I am writing :
SELECT P.PNAME, I.ID, I.SUMMARY, ILT.LINKNAME FROM ISSUELINK IL
LEFT OUTER JOIN ISSUELINKTYPE ILT ON IL.LINKTYPE=ILT.ID
LEFT OUTER JOIN JIRAISSUE I ON IL.SOURCE=I.ID
LEFT OUTER JOIN PROJECT P ON I.PROJECT=P.ID
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
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