Can I search sub issues in the database?

Deleted user April 23, 2015

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

 

 

 

1 answer

0 votes
Artur Karpiński April 23, 2015

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

 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events