Background Script to update Date Fields

Community Alums · ‎09-13-2019

Hi all,

I have to update some records in Change table i.e i have to set work start with created date , work end with created +30 seconds .

I have written like below but not working

Can you please help

var gr= new GlideRecord('change_request');
gr.addEncodedQuery('short_descriptionLIKEISPW-change^active=true^sys_created_by=ispw');
gr.setLimit(2);
gr.query();
while(gr.next())
{
gr.work_start = gr.sys_created_on;
gr.requested_by_date = gr.sys_created_on;
var date = new GlideDateTime('sys_created_on');
gr.work_end = date.addSeconds(10);
gr.update();
}

VigneshMC · ‎09-13-2019

Try

var gr= new GlideRecord('change_request');
gr.addEncodedQuery('short_descriptionLIKEISPW-change^active=true^sys_created_by=ispw');
gr.setLimit(2);
gr.query();
while(gr.next())
{
gr.work_start = gr.sys_created_on;
gr.requested_by_date = gr.sys_created_on;
var date = new GlideDateTime(gr.sys_created_on);
date.addSeconds(30);
gr.setValue('work_end', date.getValue());
//gs.print(date.getValue());
gr.update();
}

View solution in original post

Omkar Mone · ‎09-13-2019

Hi

Can you try with

var date = "";

var gr= new GlideRecord('change_request');
gr.addEncodedQuery('short_descriptionLIKEISPW-change^active=true^sys_created_by=ispw');
gr.setLimit(2);
gr.query();

while(gr.next())
{

var createdOn = gr.sys_created_on;
gr.work_start = gr.sys_created_on;
gr.requested_by_date = gr.sys_created_on;
date = new GlideDateTime(createdOn);
gr.work_end = date.addSeconds(10);
gr.update();
}

I have not tried it. But you give it a try and let me know

Regards,

Omkar Mone

Community Alums · ‎09-13-2019

Thanks for reply,

Not working

Omkar Mone · ‎09-13-2019

Hi

Try this once -

var date = "";

var gr= new GlideRecord('change_request');
gr.addEncodedQuery('short_descriptionLIKEISPW-change^active=true^sys_created_by=ispw');
gr.setLimit(2);
gr.query();

while(gr.next())
{

var createdOn = gr.getDisplayValue('sys_created_on');
gr.work_start = gr.getDisplayValue('sys_created_on');
gr.requested_by_date = gr.getDisplayValue('sys_created_on');
date = new GlideDateTime(createdOn);
gr.work_end = date.addSeconds(10);
gr.update();
}

Community Alums · ‎09-13-2019

not working