When the state changes to resolved need current date and time on sc task in the custom field name(reopen date/time).

[Shweta Kasbe1]

I need current date/time on sc task r(esolved field) when state ritm state changes to resolved 

I tried using br but didn't work.Please help me in this.

var gr2 = new GlideRecord('sc_task');
var gdt = new GlideDateTime();
current.u_resolved_time = gdt;
gdt.addDays(2);
gr2.update();

[Aman Kumar S]

Write after BR on the RITM table

Use below script:

var gdt = new GlideDateTime();
var resolvedDate = gdt.addDays(2);
var gr2 = new GlideRecord('sc_task');
gr2.addQuery("request_item", current.getUniqueValue());
gr2.query();
While(
   
   gr2.setValue("u_resolved_time", resolvedDate);
   gr2.update();
}

Feel free to mark correct, If I answered your query.

Will be helpful for future visitors looking for similar questions 🙂

[Shweta Kasbe1]

I tried for script but its not working. Also i have put this condition

[Aman Kumar S]

The BR should be after update and not insert, because you want to run the BR whenever there is a update on RITM form.

Feel free to mark correct, If I answered your query.

Will be helpful for future visitors looking for similar questions 🙂

[Ankur Bawiskar · Accepted solution]

Hi,

your BR would be after update on RITM

State [Changes to] Resolved

Script:

var gdt = new GlideDateTime();
var taskRec = new GlideRecord('sc_task');
taskRec.addQuery("request_item", current.getUniqueValue());
taskRec.query();
while(taskRec.next()){
	taskRec.setValue("u_resolved_time", gdt);
	taskRec.update();
}

Regards
Ankur