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
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