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; } } }

Relationsships between tables in Jira

Christian Schou

I have researched a lot on this topic, and i really can't find anything about it. So now im hoping that you guys can help me.

At the momemt im working with Business Intelligence and i have two things that i would like to know:

How is jira_issues related to jiraissue table?
How can i see which issues belongs to which in epic? What are their relations?

Thanks in advance

//Christian

Accepted answers

Nic Brough -Adaptavist-

1. It isn't. Jira_issues is not something jira does.

2. Look at the custom field Epic Link.

However, a much better recommendation here - stop looking at the database. It's NOT intended for reporting, it's not suitable for it, and it's the worst possible way to look at Jira data.

All comments

Nic Brough -Adaptavist-

1. It isn't. Jira_issues is not something jira does.

2. Look at the custom field Epic Link.

However, a much better recommendation here - stop looking at the database. It's NOT intended for reporting, it's not suitable for it, and it's the worst possible way to look at Jira data.

Christian Schou

Hi Nic,

Thank you for your quick answer. I will notice that.

Do you have another better way of looking at Jira data, since it's not intended for reporting?

Warren_mz9b4z

Use the REST API as documented here for Cloud

Christian Schou

Hi Warren,

Sorry i forgot to say that Jira has been installed on a local server.

Thanks.

Welcome!

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

Quick Links

Find more posts tagged with

jira

database