Where are "Epic link" records stored in JiraDB?

[Иван Мельник]

Could you plz help me to find out where the links between issue and epics are stored in JiraDB.

jiradb.issuelink has no such data

it seemed to be store in jiradb.customfieldvalue (because we can find "epic link" customfield in jiradb.customfield) but there is no such data as well

PS The data from JiraDB is used in Microsoft reporting services for complex reports.

Not for malipulations avoid JIRA Application or JIRA Rest API

[LeymanVladislav]

select il.source epick_link from issuelink il
where il.destination = issue.id
and il.linktype = 10170

[Nic Brough -Adaptavist-]

That will almost certainly only be right for some Jira installations.

Please don't encourage people to do bad things like use the database directly.

[Nic Brough -Adaptavist-]

Another good reason you should be using the APIs, rather than the database.

Last time I looked, there's a hidden link type in the issuelink table.

[Иван Мельник]

Thanks a lot. I've found them in jiradb.issuelink