How to query parent links for epics in database - Initiative Links

[Arron Varga]

Our company created a report linking our Jira epics to our ALM tool.

Part of the report they would like the Parent Link from the Epic to be display in the report.

The Parent Link is linked to initiatives and I cannot find where this data is stored.

From what I can tell this is somewhere in the Portfolio tables but I have not been able to find the information.

Can someone point me to the table in the Database?

Thanks

[Andy Nguyen]

Hey Arron,

Not sure if you've found the answer yourself in the last 12 months ;) but I'm searching for the same thing and got to know that the link is stored in table entity_property, as per https://jira.atlassian.com/browse/JPOSERVER-2370.

A query like this works for me:

select * from entity_property where json_value like '%parent_id%';

Column entity_id gives you the IDs of the child issues, and column json_value gives you those of the parents.