Update Custom field values without affecting the existig issues

[VENKATESHWARARAO]

Hi,

We have the custom field Severity with the values 

• Critical
• Major
• Minor
• S3 : Major
• S2 : Critical
• S1 : Blocker
• S4 : Minor
• S1
• B
• A
• C
• D

we need to customize these values to S1, S2, S3, S4 mapping the old ones like

S1 ----> Critical, S1: Blocker, A, S1

S2 ----> Major, S2: Major, B

S3 -----> Minor, S4: Minor, C

S4 -----> D

When I am trying to create the new custom Context and mapping to the new projects, we have lost the issue data. Could you please suggest the steps to update the values from data base or using script runner.

Thanks in advance.

Thanks,

VenkateshwaraRao 

[Juan Manuel Ibarra]

Hello,

The values of the customfields or customfieldValues have an id and a value for example your value S1: Blocker has the id 190103

This id is the one that relates the issues to the values of the field, therefore in the database a KEY-123 issue has the value 190103 for your CF.

When you create a new context, the fields of that new context have a different id, so if you assign a new (different) context to the project, the new field "S1" will have a different id than S1 of the original context.

Also, since your context does not have the other value and the id is not available, the historical information will be lost.

What this allows is that when editing the name of a value it is updated in all tickets and that is why the values of the custom fields can be disabled but not deleted

Unfortunately if you are going to use a new context you will have to reassign the values to the cf pointing to the new options.