We are reviewing the back-end database and are having problems associating the parent/child relationships through the JIRA projects. When we are reviewing the UI we see numerous issues under this initiative but they are not showing up through the SQL query. Please see example below we have Initiative Maintenance Initiatives/ MINT-5 and under we see numerous issues. When we run the following query all the issues in the UI results are not returned. We are trying to understand how to view all the parent/child relationships and do not understand what query to use to see these results.
Query: select * from JIRASchema.issuelink where SOURCE = 195170 (19 rows)