Mail script is not printing the desired data, can't determine why.

[Ryan Sonneson1]

I'm currently building out a notification for when an assessment survey comes back with a subpar result.

I've been successful in triggering the notification via an event, but the e-mail that gets sent is blank. 

My email scripted is named assessment.failed.body and I am calling it in the Notification as such: 

${mail_script:assessment.failed.body}

Because I can't seem to dot-walk my way to get the data from the asmt_assessment_instance_question table that corresponds with the asmt_assessment_instance, I had to create a script to display the end-users responses for my management to be able to see pertinent information in the email notification. 

Below is the script: 

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

          // Add your code here
			
			var gr1 = new GlideRecord('asmt_assessment_instance_question');
			var gr2 = new GlideRecord('asmt_assessment_instance_question');
			var gr3 = new GlideRecord('asmt_assessment_instance_question');
			var gr4 = new GlideRecord('asmt_assessment_instance_question');
			var gr5 = new GlideRecord('asmt_assessment_instance_question');
			var gr6 = new GlideRecord('asmt_assessment_instance_question');
	
			var q1 = "How courteous and respectful was the technician who responded? (1=poor, 5=excellent)";
			var q2 = "Please rate the technical competency of the technician serving you (1=poor, 5=excellent)";
			var q3 = "How satisfied are you with your overall service experience? (1=not at all, 5=completely)";
			var q4 = "How satisfied were you with the response time to your incident? (1=not at all, 5=completely)";
			var q5 = "Was the IS Department able to resolve your issue?";
			var q6 = "Any other comments you would like us to know?";
	
			var query1 = 'instance=' + current.sys_ID + '^metric=142a2c44d7211100158ba6859e6103a4';
			var query2 = 'instance=' + current.sys_ID + '^metric=542a2c44d7211100158ba6859e6103a4';
			var query3 = 'instance=' + current.sys_ID + '^metric=d42a2c44d7211100158ba6859e6103a4';
			var query4 = 'instance=' + current.sys_ID + '^metric=d02a2c44d7211100158ba6859e6103a4';
			var query5 = 'instance=' + current.sys_ID + '^metric=942a2c44d7211100158ba6859e6103a4';
			var query6 = 'instance=' + current.sys_ID + '^metric=902a2c44d7211100158ba6859e6103a4';
	
	
			gr1.addEncodedQuery(query1);
			gr1.query();
			if(gr1.next())
				{
					var value1 = gr1.getValue(value);
					template.print(q1);
					template.print(value1);
				}
			
			gr2.addEncodedQuery(query2);
			gr2.query();
			if(gr2.next())
				{
					var value2 = gr2.getValue(value);
					template.print(q2);
					template.print(value2);
				}
	
			gr3.addEncodedQuery(query3);
			gr3.query();
			if(gr3.next())
				{
					var value3 = gr3.getValue(value);
					template.print(q3);
					template.print(value3);
				}
	
			gr4.addEncodedQuery(query4);
			gr4.query();
			if(gr4.next())
				{
					var value4 = gr4.getValue(value);
					template.print(q4);
					template.print(value4);
				}

			gr5.addEncodedQuery(query5);
			gr5.query();
			if(gr5.next())
				{
					var value5 = gr5.getValue(value);
					template.print(q5);
					template.print(value5);
				}
	
			gr6.addEncodedQuery(query6);
			gr6.query();
			if(gr6.next())
				{
					var value6 = gr6.getValue(string_value);
					template.print(q6);
					template.print(value6);
				}
	
})(current, template, email, email_action, event);

//Query 1 is How courteous and respectful was the technician who responded? (1=poor, 5=excellent)
//Query 2 is Please rate the technical competency of the technician serving you (1=poor, 5=excellent)
//Query 3 is How satisfied are you with your overall service experience? (1=not at all, 5=completely)
//Query 4 is How satisfied were you with the response time to your incident? (1=not at all, 5=completely)
//Query 5 is Was the IS Department able to resolve your issue?
//Query 6 is Any other comments you would like us to know?

The resulting e-mail notification comes through blank and I can't determine where I went wrong. I am very green when it comes to scripting in js and using GlideRecords, so I could be so far off base. 

Any feedback would be greatly appreciated. 

[JC Icaro1]

A quick issue I found is the sys_id on query1 to query6 - it should be sys_id (all lowercase),  you had sys_ID.

[Ryan Sonneson1]

Thank you, I'm sure that would have caused issues if the script was firing correcting.

I corrected that typo but it's still triggering as a blank notification. 

[DScroggins]

Hello. In each of your GlideRecord queries you are attempting to get the value of a field. It doesn't seem like you have defined the variable 'value' as that is what is being referenced. For example in the gr1 query you are trying to call the getter gr1.getValue(value). You would need to have defined the variable value otherwise you will get a blank response. Try defining that and then your script should work.

[DScroggins]

Your gr6 query is calling the undefined variable 'string_value' as well. That too will need to be defined. If they are the names of fields then you just need to wrap in quotes like so gr6.getValue('string_value').

Oh and template.print(gr1) won't display anything. Update to gr1.getDisplayValue().

Do the same for the others gr2 - gr6.