Want to update Opened Date on Incident Record by Glide Record Update

[SNOW46]

Hi All,

I have one requirement to update one Incident Record Opened Date Field from 

"2018-12-20 20:37:44 3mo ago" to "2018-12-27 20:37:44 7d ago" via Glide Record Update.

Can anyone let me know how to glide the Incident Table and update the Record in the back end?

Thanks in advance..

[asifnoor]

Hi 

Use gr.addQuery("sys_id","your incident sys_id") and it will work for 1 record.

[Varsha21]

Hi,

Any updates?

you can use this code in background script as well as in fix script.

advantage with doing fix script is , we can capture script into update set and move to test and production instance.

thanks,

[SNOW46]

Hi Varsha,

Thanks for your quick help. It really worked for me. Thanks a lot....

[Tarique2 · Accepted solution]

you can run the below code in background script by adding your specific incident number and date value.

var gr=new GlideRecord('incident');
gr.addQuery('number', 'INC#####');
gr.query();
if(gr.next())
{
gr.opened_at='2018-12-27 20:37:44';
gr.update();
}