Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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

1 answer

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.

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

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

Events near you