Hi everyone .. Changing values in an existing field

have a custom field that has initials in eg jc, ab, do, mh  etc...but now want to have full names such as Jim carr, Andy bubble, David odd, michael Henderson etc and more that were in the original field.... What's the best way to do this, just create a new custom field or can I do a mapping exercise as obviously already have records that just have the initials. Thanks

2 answers

0 vote

What type of field is it?  If it's a select list, you can rename the options.  If it's text, you'll have to bulk-edit the content, or bulk-edit to create the data in a new field.

This is a select list, so if it says jc just rename this to Jim Carr.....

so the project I am in has just initials what do I do if I don't want to change the field itself in case it is used in other projects...can I map jc to Jim Carr in the new field update all the current records in the project and remove the old field with just initials so all records will then have my new field but instead of displaying jc it will display Jim carr...so do I just use this bulk edit option?

It depends on the goal. I'm not sure exactly what your aim is, so it might be easier to say what is happening behind the scenes. When you've got an option in a select list, it's tied to the issue via an id, not the actual content (it used to be content, but that changed in Jira 4.something if my memory serves). So what JIRA actually has in the database is something like "for issue abc-123, custom field 10010 stores option 10410". When told to display the field, it goes off to an "options" table and says "what's the label for option 10410?", to which the response is currently "jc". If you change the label of the option to "Jim Carr", no issue data changes, it's just the label. That change applies globally - all "jc" options will now display as "Jim Carr". If you don't want to upset other projects, then yes, you will need a *new* field and have do do some bulk edits. Probably "project = A and initials field = jc", then the update will be "set new name field to Jim Carr"

Nic yes the last thing you suggested is what I want to do....so

1) create new field with full names

2) add new field to project

3) map existing field with initials for existing records to new field so for a record that currently shows jc I will want the new field to say Jim Carr.

4) remove old field with initials and new field only displayed.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,336 views 14 20
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot