Jira SQL - How to map Story/Task to Epic/Feature/Initiative

[talha Parvaiz]

Good day,

Through the back-end Jira DB tables, I want to identify the project hierarchy associated to the ticket

as an example I should be able to map Sub task to Story -> Epic -> Feature -> Initiative

Please advise which tables to use and how to create the join to JiraIssue table

[Nic Brough -Adaptavist- · Accepted solution]

Don't bother to try to do this from the database, it's slow, inefficient and clunky, you'll need to be reading 16 tables and joining them in multiple places.

Please, stop looking at the database and use the API to fetch what you're looking for.

[talha Parvaiz]

Can you please let me know the table names

thabks

[Nic Brough -Adaptavist-]

Jiraissue, issuelink, nodeassociation and half the AO tables related to Advanced Roadmaps or the ones related to Structure or however else you have done features and initiatives.

It really is a mess in there, you are using the single worst possible way to approach it.

[talha Parvaiz]

?