Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

SQL query to export Issuekey-Portfolio Team id


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?


1 answer

0 votes

Hello @Cristina_Abunei


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.

Thank you,


Suggest an answer

Log in or Sign up to answer

Atlassian Community Events