How to list all previous Project Keys in Jira
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
When a Project Key is renamed in Jira, accesses to old Issue Keys are automatically redirected to the latest current Project holding that Project Key.
This article shares an example of how to list all previous Project Keys.
Environment
Any Data Center version of Jira Software or Jira Service Management.
Solution
This database query will show all current and historical Project Keys:
1
select * from project_key order by project_id, id, project_key;Sample output:
1
2
3
4
5
6
7
id | project_id | project_key
-------+------------+-------------
10000 | 10000 | SCRUM
10001 | 10001 | KANBAN
10100 | 10100 | PR1
10101 | 10100 | PR2
10102 | 10100 | PR3Notice how PR1, PR2 and PR3 all point to the same project_id, meaning they were all past keys to the same Project. The lowest "id" means the original key and the highest, the "current".
On the project table we can see both the current and original Project Keys:
1
select id, pname, pkey, originalkey from project;Sample output:
1
2
3
4
5
id | pname | pkey | originalkey
-------+----------------+--------+-------------
10000 | SCRUM | SCRUM | SCRUM
10001 | KANBAN | KANBAN | KANBAN
10100 | Project rename | PR3 | PR1Was this helpful?