SQL query to export Issuekey-Portfolio Team id

[Cristina_Abunei]

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!

[Mohamed Benziane]

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

[Cristina_Abunei]

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

[Trupti Kamble]

Hi Cristina,

Is this resolved?

Thank you,

Trupti