How to restore to old option value of custom field?

[Hisamitsu Koga]

Let me assume there is a custom field (select list (single choice)). There are two contexts in the custom field.

One project uses one context in this custom field and another project uses in another context in this custom field. One project has some existing tickets with this custom field and change the context to another context

in the custom field. This means option value in current existing tickets will be changed to another value. Right?

I would like to revert to original option value in current existing tickets. How can I do this? Please let me know.

[Vasiliy Zverev]

Here is action to restore options:

1. Restore JIRA from xml backup on test instance
2. select all issues where this field is not empty: "field name" is not emty
3. Do bulk update for each option on product instance
   1. Select issues with JQL: issues in (list on issue keis from test instance)
   2. do bulk update

[Nic Brough -Adaptavist-]

If a value is not valid for a field, you can't have it in that field, it needs to be changed to a valid one.

The best you can do is create a copy of the value that is becoming invalid, make the change, and then make the new invalid value "archived" in the options so that it can't be chosen again.

If you've already made the change and flipped over the invalid options to something, then you'll need to add the duplicate option, get a list of the ones that have been updated, and bulk-edit them to take up the new (but archived) option.

[Hisamitsu Koga]

Already deleted one context which current existing tickets with old option value. In DB those tickets

have old option value and if uses same custom field / option name to search tickets, but current option value is different from old option value, so we can't search tickets as our expectations I guess. Right? 

[Nic Brough -Adaptavist-]

Correct.

[MattS]

Doesn't ScriptRunner have a builtin script to help with this case?

[Nic Brough -Adaptavist-]

Not specifically, but the bulk import and update en-masse might be able to do it.  A self-written console script could do it too of course.