nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

SQL Query for Project Shortcuts

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!

Accepted answers

Hana Kučerová

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.

All comments

Nic Brough -Adaptavist-

What do you mean by "project shortcuts"?

Hana Kučerová

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.

Mohamed Benziane

I think he means that :

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

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server

database

data-center