Update custom table record based on RITM variables when one of the tasks is marked as closedcomplete

Lakshmi Sharma · ‎07-17-2023

Hi,

I am trying to update a custom table record with RITM variables when task is closed as complete. I have a catalog item where I pick this record (ex:Incident) I will fill in variables and expectation is once my task in the flow is marked as complete by support team, I want variables to automatically update my incident fields with variable values submitted by requestor.

I am trying to achieve through run script but failing to update the (incident) record. Additionally I would need to verify the task state and only if state is closed complete this update must happen. My run script queries incident table with the variable used to select target record. Once found the record I trying to map variables with incident fields but that dosent work as well.

Any sort of help is much appreciated, Thanks in Advance!!

Ankur Bawiskar · ‎07-17-2023

@Lakshmi Sharma

this should update and not insert

var TargRec = current.variables.target_record;
var UndRec = new GlideRecord('incident');
UndRec.addQuery('sys_id', TargRec);
UndRec.query();
if(UndRec.next()){
	UndRec.short_description = current.variables.shrt_desc;
	UndRec.description = current.variables.desc;
	UndRec.update();
}

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Lakshmi Sharma · ‎07-19-2023

Hi @Ankur Bawiskar accepted the solution already, however as a part of original question if you can suggest on the update happening only upon task closure with state closed complete, that would be great!