nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!

Comments

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

unknown

Hi Cristina,

Is this resolved?

Thank you,

Trupti

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

advanced-roadmaps