SQL Query for Project Shortcuts

[Clark Everson]

In Jira you can create project shortcuts. We are in the middle of a migration and we need to query the database to find all Jira projects that have a shortcut to another Jira project

When we last did this it was a lot of guessing and I can't find any queries for it in Community already.

What we are looking to get are a list of the projects (name and key) that contain a project shortcut and the link (URL etc) to the shortcut itself

Appreciate the help in advance!

[Hana Kučerová · Accepted solution]

Hi @Clark Everson ,

please try

select * FROM "AO_550953_SHORTCUT"

I believe this is the table, where all the project shortcuts are stored.

There's PROJECT_ID column, where project id is stored, so you will be able to determine the project.

[Nic Brough -Adaptavist-]

What do you mean by "project shortcuts"?

[Mohamed Benziane]

I think he means that :

https://confluence.atlassian.com/jiracoreserver072/project-shortcuts-829092491.html

[Clark Everson]

Yeah I was referring to exactly what @Mohamed Benziane  linked to. Forgot to include the link