Changed Field type from Choice to Reference List - values gone

[Shane J]

Rookie mistake here - I applied an Update Set in which a field was switched from a Choice field to a Reference field.   All values in the field (seem) to have been wiped out, with no way to restore.   I'm not even sure backing out the Update Set would do anything, though outside of this one field everything else is fine (and there were a lot of changes...).

Odd thing though, existing reports based on that field - are still working.   It's as if the value is there (somewhere).

Has anyone done the same thing, and if so, did you find a way to get the values back?

[pratul]

Hi

Have you tried looking out for the choice values in the sys_choice table.

Regards

Pratul Agarwal

[Shane J]

I haven't but what will that do for me?

[domaners]

I think the original values will still be stored in the database, unless something interacts with the record to change it. Sounds like you're in a sticky situation here, but have you tried simply switching the field back to a string in the dictionary?

Otherwise, the data may still be available in the history or audit tables. I s auditting enabled for your tables? Otherwise, if you look at the History values for these records, what do you see?

[Shane J]

This is field on the Request Item table.   I didn't try reverting it back to Choice (seems to be an option under Versions?) mainly because I don't know what that will do.

History does show value that it should have been.   So if that's the case, shouldn't I be able to run a script to pull those from the audit table?

EDIT:   Upon further review, the History is not always accurate.   Sometimes it's just empty.