How to appear the values of a deleted custom field?

[Tsol]

Hi everybody,

in a issue type i had created a text custom field. The custom field was deleted. Is there any way to have again the values in the view issue screen?

Thanks in advance

[Dieter · Accepted solution]

When you delete a custom field the associated custom field values are also deleted. Definitely! Hopefully you have made a XML backup or a native database backup and can restore that. If yes and you are safe in SQL you can try to transfer the missing rows from table customfieldvalue in the restored backup into the existing database. Things would get a lot more complicated if your fields were option valued fields like select lists since that would mean you would have to recreate the options in table customfieldoption as well and create the right option value in attribute stringvalue of customfieldvalue.

[Dieter]

Just noticed, that it was just a text field, so your chances are not that bad and you cna get that fixed by transferring the customfieldvalue rows matching your custom field id xxxxx. You can get these using: select * from customfieldvalue where customfield = xxxxxx in your redtored database

[Tsol]

i'll try that. Hope it works

Thanx

[Dieter]

try it on a copy of your productive system first ;-)

[Tsol]

yeap, i'll try it in a test instance.