Can I query something to find the repo URL path from the repo number?

[jcurleyWR]

From the admin side of stash, we have the repository numbers. From the command line, can I query something, like the database, to learn the URL path for each number? I know the server name, so I just need the {project}/{repo.git} value.

Thank you,

John

[jcurleyWR · Accepted solution]

I found a way to query the DB:

select repository.id,project.project_key,repository.slug FROM repository LEFT JOIN project on project.id=repository.project_id order by repository.id;

[cofarrell]

Hi John,

You might be interested in the following plugin:

https://bitbucket.org/atlassian/stash-reponame-plugin

Charles