Field values in historical records disappeared after editing that field's reference

[karolisjon]

Hello, we've just noticed an issue and I can't find an answer/solution. We had a requirement to edit an already existing reference field (Problem Manager) on the problem record. We changed the Reference table from sys_user to sys_user_grmember and added a few conditions. Everything was working as expected but then we noticed, that this action erased Problem Manager field's values in historical records. For now the update set was backed out and that returned the missing values. 

How can we change the reference table + add reference qual conditions without deleting historical data from the field? 

Thanks!

[Aman Kumar S]

Awesome, mark the response as correct, so it will end up in solved queue

[Aman Kumar S]

Hi @karolisjon 

Feel free to mark correct, If I answered your query.

Will be helpful for future visitors looking for similar questions 🙂