You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I need an export for all the issues that have the Portfolio Team set containing the issuekey and the team id.
JQL retrieves the team name and I also have over 30 000 such records so this doesn't help
I'm trying to find a connection between the jira issues and the Portfolio database tables in order to get this info but I can't find any documentation regarding how this relation is established.
The teams are not in customfieldvalue table, even though I can find the Team in the customfield table.
AO_D9132D_ASSIGNMENT_EXT seemed to be the answer but for one issue id it retrieves hundreds of records, none of which contain the correct Team id.
Has anyone managed to do this/found some documentation on the Portfolio database schema?
You can try this
It will retrieve all table associated to portofolio. It could be a good start.
Hope this helps
I have the tables retrieved from the JIRA database but no idea how they relate to each other and to the other JIRA tables.