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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.