Interested in a ServiceNow event built for developers? Registration for now[dev]26 is officially open!

When label changes on sys_choice table for any element didnt update the updated timestamps on prev

ajayvemula1
Tera Contributor

When a choice label is changed in the sys_choice table, existing records display the new label, but their updated timestamps remain unchanged.

For example, the Category field on the problem table has a choice labeled Software, which is used by 100 existing records. When the label is changed to Software IT, all 100 records display the new label, but their updated timestamps do not change.

How can we capture the time of this label change on all affected existing records?

2 REPLIES 2

OlaN
Tera Sage

Hi,

That's just how the platform works. You're not actually changing the records using the choice-value, you are only changing the display value of the choice itself.

Same thing would go if you were to change the same of any reference for example a user record.
Say you'd change Beth Anglin to something else, like Beth Anglin-Smith, then all the Incident records that exist would display the new name, and not the old one, but none of the records would be updated, since the value hasn't changed, only what's displayed.

ajayvemula1
Tera Contributor

Hi OlaN,

Thank you for your reply.

When a choice label changes in ServiceNow, the updated timestamps on existing records remain unchanged. As a result, Visibility’s downstream data processes cannot detect the change. ServiceNow displays the updated label, while Visibility continues to show the previous label, causing data inconsistencies between the two platforms.

Is there a way to update the timestamps on the affected existing records when a choice label changes so that Visibility can detect and synchronize the change?