In which table does a Parent ID of an Sub-task stored in?

Anudeep Gudipelli

Hi All, 

I am looking for a database table relation/information for parent id of an sub-task, I would like to build a query to get the parent id(jira issue number) which is associated to the sub-task. 

Matt Doar _Adaptavist_

I think it is in the issuelink with the linktype of either subtask or Parent/Child. The source and destination are the issue ids of the parent and child (subtask) issue. Sorry for the lousy formatting but the bestway to confirm this is to play about with a test DB and Jira

mysql> desc issuelink;

+-------------+---------------+------+-----+---------+-------+

| Field       | Type          | Null | Key | Default | Extra |

+-------------+---------------+------+-----+---------+-------+

| ID          | decimal(18,0) | NO   | PRI | NULL    |       |

| LINKTYPE    | decimal(18,0) | YES  | MUL | NULL    |       |

| SOURCE      | decimal(18,0) | YES  | MUL | NULL    |       |

| DESTINATION | decimal(18,0) | YES  | MUL | NULL    |       |

| SEQUENCE    | decimal(18,0) | YES  |     | NULL    |       |

+-------------+---------------+------+-----+---------+-------+

5 rows in set (0.01 sec)

 

mysql> select * from issuelinktype;

+-------+-------------------+---------------------+----------------------+------------------------+----------+

| ID    | LINKNAME          | INWARD              | OUTWARD              | pstyle                 | POSITION |

+-------+-------------------+---------------------+----------------------+------------------------+----------+

| 10000 | Blocks            | is blocked by       | blocks               | NULL                   |        1 |

| 10001 | Cloners           | is cloned by        | clones               | NULL                   |        2 |

| 10002 | Duplicate         | is duplicated by    | duplicates           | NULL                   |        3 |

| 10003 | Relates           | relates to          | relates to           | NULL                   |        4 |

| 10100 | jira_subtask_link | jira_subtask_inward | jira_subtask_outward | jira_subtask           |     NULL |

| 10200 | Epic-Story Link   | has Epic            | is Epic of           | jira_gh_epic_story     |     NULL |

| 10201 | Parent-Child Link | is child of         | is parent of         | jira_jpos_parent_child |     NULL |

+-------+-------------------+---------------------+----------------------+------------------------+----------+

7 rows in set (0.01 sec)