Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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:

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

Is there a patch that you can provide?

1 answer

0 votes
Thomas Deiler Community Leader Apr 13, 2021

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


Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you