Hi to all
I wanna search relation between parent-issues and sub-issues in the JIRA DB..
However I can't search about that..
such as below:
* parent issue : Bug-12
* sub issue of "Bug-12" : Sub-1, Sub-2, Sub-3
Then It is stored at "jiraissue" table on JIRA DB. There is no information about relation betwween "Bug-12" and "Sub-1", "Sub-2", "Sub-3"...
If I want search a parent Issue and sub issue using by SQL, what is a query to search it??
You need query similar to this:
SELECT TOP 100 * FROM jiraissue i JOIN issuelink il ON il.SOURCE = i.ID JOIN issuelinktype ilt ON ilt.ID = il.LINKTYPE WHERE ilt.LINKNAME = 'jira_subtask_link';
Parent / subtask is special type of link in JIRA
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in talking to 20 people planning t...
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs