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
4,364,800
Community Members
 
Community Events
168
Community Groups

SQL query to export Issuekey-Portfolio Team id

Hello,

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?

Thanks!

1 answer

0 votes

Hello @Cristina_Abunei

 

You can try this

https://jiradomain/plugins/servlet/active-objects/tables/list

 It will retrieve all table associated to portofolio. It could be a good start.

Hope this helps

Regards

Hi,

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,

Cristina

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events