How to compare two field configurations in JIRA?

[Nithya Ananda]

We are consolidating field configurations for easy maintenance. 

What is the easy way to compare any two field configurations, so that we can check for the difference and adjust in the consolidated FC?

[Rachel Wright]

Hi Nithya,

Congrats on cleaning up!

If you have Cloud, you could launch two browsers to visually compare the settings, or copy/paste the data from both into a diff program or program that will help you highlight differences, like Excel.

The best way though, if you have JIRA Server, is to get the information to compare out of the database.  Look in the "fieldlayout" table for the scheme ID and use it to find the settings in the "fieldlayout" column of the "fieldlayoutitem" table.  You may also want to join the "customfield" table to get the custom field names instead of just the field IDs.

Of course, the more fields you have the harder the comparison is.  One more reason, of many, to keep your custom field list tidy too!  :)

Hope this helps,

Rachel Wright