How to safely delete unused Field Configurations 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
Over time, Jira instances may accumulate unused Field Configurations. fieldlayout and fieldlayoutitem table stores information about Field Configurations and their associated items. This article provides a step-by-step guide to safely delete unused Field Configurations from your Jira database using custom SQL queries.
Solution
Stop Jira service
Take a backup of Jira database
Always back up your data before performing any modification to the database. If possible, try your modifications on a test server.
Run the SQL Query
1 2DELETE FROM fieldlayoutitem WHERE fieldlayout NOT IN (SELECT fieldlayout FROM fieldlayoutschemeentity) AND fieldlayout NOT IN (SELECT id FROM fieldlayout WHERE Name = 'Default Field Configuration'); DELETE FROM fieldlayout WHERE id NOT IN (SELECT fieldlayout FROM fieldlayoutschemeentity) AND name NOT IN ('Default Field Configuration');The first query deletes entries from the
fieldlayoutitemtable where thefieldlayoutis not associated with any Field Configuration Scheme and is not the 'Default Field Configuration'. The second query deletes entries from thefieldlayouttable that are not linked to any Field Configuration Scheme and are not the 'Default Field Configuration.'Start Jira service
Was this helpful?