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

Santhosh Vegolam

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 

Sean Binny

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