Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

somebody help to debug the email script code

Nikita35
Kilo Guru

(function runMailScript(/* GlideRecord */ current, /* TemplatePrinter */ template,
/* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action,
/* Optional GlideRecord */ event) {

var instance = new GlideRecord('asmt_assessment_instance');
instance.addQuery('task', current.sys_id);
instance.query();
while(instance.next())
{
url = '<a href="'+gs.getProperty('glide.servlet.uri') +'nav_to.do?uri=%2Fassessment_take2.do%3Fsysparm_assessable_sysid=' +instance.sys_id + 'sysparm_assessable_type%3D4b8c6704dbaa7300f3e3a08a4896191f'">'+'Click here'+'</a>';
template.print(url);
}

})(current, template, email, email_action, event);

find_real_file.png

 

regards

 

1 ACCEPTED SOLUTION

Mike Patel
Tera Sage

try

(function runMailScript(/* GlideRecord */ current, /* TemplatePrinter */ template,
/* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action,
/* Optional GlideRecord */ event) {
	
	var instance = new GlideRecord('asmt_assessment_instance');
	instance.addQuery('task', current.sys_id);
	instance.query();
	while(instance.next())
		{
		url = '<a href="'+gs.getProperty('glide.servlet.uri') +'nav_to.do?uri=%2Fassessment_take2.do%3Fsysparm_assessable_sysid=' +instance.sys_id +'sysparm_assessable_type%3D4b8c6704dbaa7300f3e3a08a4896191f">Click here</a>';
		template.print(url);
	}
	
})(current, template, email, email_action, event);

View solution in original post

19 REPLIES 19

Looks like I had too many single-quotes. I put it inside a text editor. Try this:

 

find_real_file.png

vkachineni
Kilo Sage

//Tested on PDI

//Also Mike's code is tested. 

 

(function runMailScript( /* GlideRecord */ current, /* TemplatePrinter */ template,
    /* Optional EmailOutbound */
    email, /* Optional GlideRecord */ email_action,
    /* Optional GlideRecord */
    event) {

    var instance = new GlideRecord('asmt_assessment_instance');
    instance.addQuery('task', current.sys_id);
    instance.query();
    while (instance.next()) {
        url = "<a href='" + gs.getProperty('glide.servlet.uri') + "nav_to.do?uri=%2Fassessment_take2.do%3Fsysparm_assessable_sysid='" + instance.sys_id + "sysparm_assessable_type%3D4b8c6704dbaa7300f3e3a08a4896191f'>" + "Click here" + "</a>";
        template.print(url);
    }

})(current, template, email, email_action, event);
Please mark Correct and click the Thumb up if my answer helps you resolve your issue. Thanks!
Vinod Kumar Kachineni
Community Rising Star 2022

Nikita35
Kilo Guru

find_real_file.png

 

Can somebody help one more time please?

try

(function runMailScript(/* GlideRecord */ current, /* TemplatePrinter */ template,
/* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action,
/* Optional GlideRecord */ event) {
	
	var instance = new GlideRecord('asmt_assessment_instance');
	instance.addQuery('task', current.sys_id);
	instance.query();
	while(instance.next())
		{
		var url = '<a href="'+gs.getProperty('glide.servlet.uri') +'nav_to.do?uri=%2Fassessment_take2.do%3Fsysparm_assessable_sysid=' +instance.sys_id +'%26sysparm_assessable_type=' + instance.metric_type + '">Click here</a>';
		template.print(url);
	}
	
})(current, template, email, email_action, event);

thank you