How to get a list of projects using default field configuration 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 you may want to get a list of projects that are using the default field configuration. In the UI, it may not be possible to get this list if there are too many project associated with the same default field configuration. The UI will only list the first 9 project and then will display "and xxx hidden projects".
Environment
Jira 7.x and later
Solution
It is possible to retrieve this information via Jira database using the following SQL queries:
List of project using a custom Field Configuration Scheme
1
2
3
SELECT p.id, p.pname
from project p
WHERE p.id IN (SELECT na.source_node_id FROM nodeassociation na WHERE na.sink_node_entity = 'FieldLayoutScheme')List of projects using the System Default Field Configuration Scheme
1
2
3
SELECT p.id, p.pname
from project p
WHERE p.id NOT IN (SELECT na.source_node_id FROM nodeassociation na WHERE na.sink_node_entity = 'FieldLayoutScheme')Was this helpful?