How to populate "sys_template" fields to incident fields in inbound action

sinu2 · ‎04-02-2019

HI all,

I have a requirement that "sys_template" fields values needs to populate on "incident" inbound email action

Please find the below script for that but it is not working..This script i have written in my inbound action (this inbound placed in incident table)

u_template is a reference field in incident table

var template_id = '4e0f98cddbbbab0022f5d404ca9619e9';
var systemp = new GlideRecord('sys_template');
systemp.addQuery('sys_id',template_id);
systemp.query();
gs.addInfoMessage("number of templates:"+systemp.getRowCount());
if(systemp.next()){
var IncRec = new GlideRecord('incident');
IncRec.addQuery('u_template.sys_id',template_id );
IncRec.query();
gs.addInfoMessage("temp sys_id is:"+IncRec);
gs.addInfoMessage("number of templates:"+IncRec.getRowCount());

if(IncRec.next()){
IncRec.state = systemp.state;
gs.addInfoMessage("checking template state:"+IncRec.state);
IncRec.short_description = systemp.short_description;
gs.addInfoMessage("checking template short description:"+IncRec.short_description);

var id = IncRec.insert();
}

}

asifnoor · ‎04-04-2019

Hi Srisk,

Actually, you can use a OOB Function ApplyTemplate to apply it to your incident. Here is how you can do this.

var template_name = 'Your Template Name'; // in place of sys_id mention your template name.

var IncRec = new GlideRecord('incident');
IncRec.applyTemplate(template_name); 
IncRec.update();

Mark the comment as a correct answer and also helpful once worked.

View solution in original post

asifnoor · ‎04-04-2019

Let me know if it has worked.

If yes, kindly mark my comment as a correct answer and also helpful.