Can I search sub issues in the database?

Question

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??

Artur Karpiński · Answer

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