Need to Update Old Records using Fix Script

[Priyanka1997]

Hi Everyone,

In Incident table, I have to change old records and condition will be like, If 'Test Completion Date' is not empty, then the 'Status' should set to "Completed".

Kindly help me If anyone used any Fix Script for such issue.

[RaghavSh · Accepted solution]

var inc = new GlideRecord('incident');
inc.addQuery('Test Completion Date' ,  '!=' , '');   // check the backend name of test completion date and modify accordingly
inc.query();
while(inc.next())
{
inc.status=3;            // check the value of completed state and mofidy accordingly.
inc.update();
}

[Priyanka1997]

Thanks @RaghavSh for your prompt reply, Its perfectly working for me.