Details
-
Suggestion
-
Resolution: Unresolved
-
None
-
None
-
10
-
1
-
Description
As a Jira Admin, I need a quick way to list all projects that are using the default priority scheme.
In the "Projects" column of the "Default priority scheme" we can only see: Global (all unconfigured projects).
This makes it difficult to determine what projects are using it.
Workaround
Use the following SQL query against the Jira database to list all projects that are not using a custom priority scheme, which indicates the default priority scheme is being used.
SELECT pname AS "Project" FROM project WHERE id NOT IN (SELECT project FROM configurationcontext WHERE customfield = 'priority' AND project IS NOT NULL)
Attachments
Issue Links
- depends on
-
JRASERVER-67462 The associate priority scheme project selector is prone to error
- Gathering Interest
-
JRASERVER-66660 Provide the ability to edit the default priority scheme
- Future Consideration
- mentioned in
-
Page Loading...