The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

how can i find tabel with contains team and issue connection?

Emiś X (Elainis)
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 26, 2017

I have to make some reports with containing issues extended by name of team it depends. I found table AO_82B313_TEAM but i can not find any dependency to jiraissue. Are those informations store anywhere in database?

1 answer

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
September 26, 2017

Yes, it's probably in one of the other AO_82B313_.... tables, but it might be in nodeassociation too.

I'd strongly recommend not trying to do this with SQL though.  The Jira database is absolutely not built for any form of reporting.  I'd be looking at writing a Jira/Portfolio add-on that does it properly.

TAGS
AUG Leaders

Atlassian Community Events