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?
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.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events