Hi Akshay,
If you change the label, it doesn't affect the data in the column.
Q: Did you create an entirely new field or just a new label for the old field? That seems like a bit of overkill. What I understood from Geoffrey is that he recommended creating a deleting and creating a new (label) record in sys_documentation.
For what it's worth, creating an entirely new field might have other implications like ACLs, scripting references, etc.
If you suspect your risk after creating a new field is negligible (low) then a simple script to copy the data from one field to the other is easy enough. You can do this in scripts background with something like this:
Standard disclaimer: The following code is untested, requires review and potential modifications.
(function () {
var rec = new GlideRecord('your_table');
rec.query();
while (rec.next()) {
rec.setWorkflow(false);
rec.autoSysFields(false);
rec.u_newfield = rec.u_oldfield;
rec.update();
}
})();
