Why do I see a custom field listed multiple times in the Issues tab?

Michael Thompson
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 8, 2017

Hello everyone,

I've been dabbling with some SQL statements to try and pull data direct from the Oracle database. Most recently I got a list of all custom fields with a pretty basic query:

Select id, cfname, description FROM customfield ORDER BY cfname ASC

I got a display of all my custom fields, but I noticed that quite a few cfnames were repeated with different ids. For example:

ID        CFName

10568  Contact Role

10567  Contact Role

10570  Contact Role

10569  Contact Role

I went back into JIRA, went to the Issues administration tab, and clicked on Custom Fields. Sure enough, I see four listings for Contact Role, and they are identical in every way.

duplicateCustFields.png

Can anyone explain how this is possible? I now see this for quite a few custom fields.

3 answers

1 accepted

1 vote
Answer accepted
Ignacio Pulgar
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 8, 2017

You may click on the cog icon > Configure in order to check the selectable options in each of those custom fields.

If the options were the same for all of them, I'd say that you may delete all but one of them.

However, as all those fields are displayed simultaneously in the same window, it is weird that users hadn't pointed out this duplicity of fields, so maybe there's a reason fir all those fields to exist.

I'd recommend avoiding the creation of fields with exactly equal names, though.

Michael Thompson
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 8, 2017

Thanks Ignacio, I did check the configurations and every facet of these fields are the same. I have noticed that since I took over as the JIRA admin, none of the custom fields I have created are duplicated. However, I also do not use duplicate names. I suppose it's possible that the previous admin repeated himself, but that would be a horrible practice for any tracking system!

1 vote
Steven F Behnke
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 8, 2017

Do you have any plugin that would be creating fields? What would be creating fields called "Contact Role"?

Michael Thompson
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 8, 2017

The former JIRA admin would have created Contact Role (no longer with the company). There are no plugins that would create the field, it's a manual process, and fields are only created by the JIRA admin (currently that's me :)), and not without a request posted to our maintenance project and approval from a manager to add the field.

0 votes
Michael Thompson
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 8, 2017

I beliieve Ignacio has led me to the answer. I checked with the Product manager who deals with the projects associated with these duplicate fields. it appears that this project tracks external customer information, including multiple company contacts. It appears that the former JIRA admin re-used the same name for custom fields.

This will be a painful maintenance task. I have 363 custom fields, but 303 unique cfnames. Time to untangle the mess.

Steven F Behnke
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 8, 2017

Wow... That is not good. :p 

Dayanand August 12, 2021

@Michael Thompson How do you able to find the duplicate 363 custom fields?

Michael Thompson
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 12, 2021

@Dayanand 

I ran a SQL query against our Oracle database.

SELECT id, cfname, description, defaultvalue
FROM customfield
ORDER BY cfname ASC

Dayanand October 20, 2021

@Michael Thompson ,

Thank you for the query also is there any way to find duplicate custom fields used per projects (project specific duplicate custom fields).

Suggest an answer

Log in or Sign up to answer