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?
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.
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