We have Duplicate Agile/Software custom fields and want to fix it

[Joe_Rady]

Identifying the custom field IDs with the SQL String:

SELECT id,cfname FROM customfield WHERE customfieldtypekey like 'com.pyxis.greenhopper.jira%' OR cfname in ('Flagged','Story Points','Epic/Theme','Business Value') ORDER BY cfname, id;

returns 1140 rows.

We found that we have about 1117 custom fields with the search word "Epic".

The solution published on:

https://confluence.atlassian.com/jirakb/duplicate-agile-software-custom-fields-after-upgrading-jira-software-779159142.html

is impractical. We cannot execute the many tasks for over a 1000 entries.

Is there a patch that you can provide?

[Thomas Deiler]

Dear @Joe_Rady ,

I recommend to write some logic around the listed SQL commands in a higher language like Java. Even with PHP it's possible.

But replicate your database first to some sandbox environment when performing the changes.

For a developer with +2 years of coding experience - a piece of cake.

So long

Thomas