Where is the association between the jiraissue and Team stored in the database

Question

I am trying to find out the "Team" association with a jiraissue in the database using SQL, but so far I have not been able to find where they are stored.  I checked customfield/customfieldvalue/nodeassociation tables, but didn't find anything. Where is that relationship stored?

Markus Huber · Answer

there are plugin, which needs the table where it is stored in, like pocket-query.

So be transparent in the db- schema is in my opinion very important.

Otherwise provide views for the data, then you can change things in background.

regards

Ravi Pothineni · Answer

Teams are stored in table "AO_15E421_TEAMS" table. Does that make it a custom field?

I know about Jira REST API, but this query is part of a larger project which integrates with other systems in the company, so I want it to work.

Bastian Stehmann · Answer

Hi @Ravi Pothineni,

Where does your Team come from?

Is it a custom field? Is it from an add-on?

Beside that, why do you want to find that in database. It is not recommend to get data direct from database, because you never know when it will change.