How to get a list of projects using the Default Priority Scheme 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
In Jira UI, when browsing to Issues > Priority Schemes, it is currently not possible to get a list all project using the default Priority Scheme. What we see is Global (all unconfigured projects).
This is currently being tracked in the following feature request: JRASERVER-67790 - Ability to list all projects that are using the default priority scheme
Environment
Jira Data Center version 7.x and later
Solution
It is possible to use a SQL query against the Jira database to achieve this.
How to get a list of project using the Default Priority Scheme:
1
2
3
SELECT pname AS "Project"
FROM project
WHERE id NOT IN (SELECT project FROM configurationcontext WHERE customfield = 'priority' AND project IS NOT NULL)How to get a list of projects using a custom Priority Scheme:
1
2
3
4
5
6
7
8
9
SELECT p.pname AS "Project",
f.configname AS "Priority Scheme"
FROM project p,
configurationcontext c,
fieldconfigscheme f
WHERE c.project = p.id
AND f.fieldid='priority'
AND f.id = c.fieldconfigscheme
GROUP BY f.configname, p.pnameTested on PostgreSQL and may need modifying for other DBMS such as Oracle or SQL Server.
Was this helpful?