nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Nic Brough -Adaptavist-

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.

All comments

talha Parvaiz

Nic Brough -Adaptavist-

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server