Forums

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

how to retrieve project names from jira database for the mentioned Github repositories or account

Santhosh Vegolam June 27, 2018

I want the query to run in my Postgres database to retrieve project names which projects are linked to mentioned GitHub repositories or account from Jira database

 

 

please help me with the query to run in postgres

 

Thanks

santhosh 

1 answer

0 votes
Sean Binny June 27, 2018

Please look at https://developer.atlassian.com/server/jira/platform/attachments/jira-7-9-2-database-schema.pdf

 

The table storing this association is jiradb.AO_E8B6CC_REPO_TO_PROJECT

 

Sean Binny

Product Manager

At a Glance Plugin

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, aafp, jira migration, marketing collaboration, end siloed work, streamline workflows, kerrie gottschalk, jira cloud admins, unified marketing, process visibility, team efficiency, cross-team collaboration

How Kerrie Gottschalk unified AAFP’s marketing team with Jira

At the American Academy of Family Physicians, siloed marketing teams faced delays and duplicate work. Kerrie Gottschalk shook things up by moving the department to Jira, streamlining processes, boosting visibility, and sparking stronger collaboration.

Read the story
AUG Leaders

Atlassian Community Events