Update field value in archive table

[emiliomancebo]

Hi I need to modify the value of a field in a record in an archive table. Is there any way to do it? thank you very much

[Jaspal Singh]

Hi Emilio,

You can try using background script for getting it done.

Link http://www.servicenowelite.com/blog/2014/1/17/how-to-use-background-scripts should help.

[sachin_namjoshi]

why do you need to update archived table data directly?

Archived tables are not designed to be updated directly.

Data from source table will be archived to your archived tables. You should update field value in your source table and then it will be available in your archived table.

Regards,

Sachin

[emiliomancebo]

Hi

I need to modify the value of a field in a record in an archive table directly because a reference field was added because in the archiving tables these fields were not saved, but in some cases this field has been saved with the wrong value, I wanted to know if it was possible to modify this value by means of a Fix Script. I have tried but it does not leave me, even if I have ACLs write on the archive table and the field if I do a canWrite () always returns false.
It is more if I restore the records, coo that remain in the archiving tables even and if I return it to archive does not take the change correctly.

Thanks!

[Aditya Telideva]

Data that is archived is not removed by any rules. I am sure the below link will be of great help to you:

ttps://community.servicenow.com/people/sergiu.panaite/blog

Thanks,

Aditya Telidevara