How to display MRVS table in Approval Notification Email

Go to solution
Si Min
Giga Expert

‎08-04-2019 02:34 AM

Hi All, 

Would like to seek some help here as I'm not able to display the MRVS table in the Approval email notification but those variables that outside the MRVS do display accordingly. 

Here is the code, and if someone can point me out where goes wrong? 

Thanks in advance. 

(function runMailScript(/* GlideRecord */ current, /* TemplatePrinter */ template,
/* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action,
/* Optional GlideRecord */ event) {
	
	template.print("Summary of Requested items:<br />");
	
	var set = new GlideappVariablePoolQuestionSet();
	
	set.setRequestID(current.getValue('sysapproval'));
	set.load();
	
	var vs = set.getFlatQuestions();
	
	for (var i = 0; i < vs.size(); i++) {
		
		if (vs.get(i).getLabel() != '' && vs.get(i).getDisplayValue()!='' && vs.get(i).getDisplayValue()!='false') {
			
			template.space(4);
			template.print(vs.get(i).getLabel() + " = " + vs.get(i).getDisplayValue() + "<br/>");
			
		}
		var mrvs;
		var rowCount;
		var ritmGR = new GlideRecord('sc_req_item');
		if (ritmGR.get(current.sys_id)) {
			mrvs = ritmGR.variables.book_details; //multi row variable set info
			rowCount = mrvs.getRowCount();
		
		if(rowCount >= 0){
			
			template.print('<table border="1px solid black" style="font-family:Arial">');
			template.print( "<tr bgcolor='#ddd'align='center'>" );
			template.print("<td style='text-align:center' colspan='10'><strong>Book Details</strong></td>");
			template.print( "</tr>" );
			
			template.print( "<tr>" );
			template.print( "<td><center><b>Type</b></center></td>" );
			template.print( "<td><center><b>Title </b></center></td>" );
			template.print( "<td><center><b>Subtitle</b></center></td>" );
			template.print( "<td><center><b>Author / Editor</b></center></td>" );
			template.print( "<td><center><b>Year of Published</b></center></td>" );
			template.print( "<td><center><b>International Standard Book Number</b></center></td>" );
			template.print( "<td><center><b>Publisher</b></center></td>" );
			template.print( "<td><center><b>URL</b></center></td>" );
			template.print( "<td><center><b>Estimated Price (SGD)</b></center></td>" );
			template.print( "</tr>" );
			
			var mvrs = current.variables.book_details;
			var ritm = current.getUniqueValue();
			var rowCount2 = mvrs.getRowCount();
			for (var a = 0; a < rowCount2; a++) {
				var row = mvrs.getRow(a);
				template.print( "<tr>" );
				template.print( "<td><center>" +row.type + "</center></td>" );
				template.print( "<td><left>" +row.title + "</left></td>" );
				template.print( "<td><left>" +row.subtitle + "</left></td>" );
				template.print( "<td><left>" +row.author_editor + "</left></td>" );
				template.print( "<td><center>" +row.year_of_published + "</center></td>" );
				template.print( "<td><left>" +row.international_standard_book_number_isbn + "</left></td>" );
				template.print( "<td><left>" +row.publisher + "</left></td>" );
				template.print( "<td><left>" +row.url + "</left></td>" );
				template.print( "<td><center>" +row.estimated_price_sgd + "</center></td>" );
				template.print( "</tr>" );
			}
			template.print('</table>');
			
		}}})(current, template, email, email_action, event);
Labels:
0 Helpfuls
  • 4,493 Views
1 ACCEPTED SOLUTION

Go to solution
Harsh Vardhan
Giga Patron
In response to Si Min

‎08-04-2019 08:12 AM

instead of using current.sys_id , replace it with current.sysapproval

try now. 

View solution in original post

33 REPLIES 33

Go to solution
Si Min
Giga Expert
In response to Harsh Vardhan

‎08-04-2019 07:15 AM

Here you go and really thanks for helping on this. 

(function runMailScript(/* GlideRecord */ current, /* TemplatePrinter */ template,
/* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action,
/* Optional GlideRecord */ event) {
	
	template.print("Summary of Requested items:<br />");
	
	var set = new GlideappVariablePoolQuestionSet();
	
	set.setRequestID(current.getValue('sysapproval'));
	set.load();
	
	var vs = set.getFlatQuestions();
	
	for (var i = 0; i < vs.size(); i++) {
		
		if (vs.get(i).getLabel() != '' && vs.get(i).getDisplayValue()!='' && vs.get(i).getDisplayValue()!='false') {
			
			template.space(4);
			template.print(vs.get(i).getLabel() + " = " + vs.get(i).getDisplayValue() + "<br/>");
			
		}
	}
	gs.log('Before mrvs');
		var mrvs;
		var rowCount;
		var ritmGR = new GlideRecord('sc_req_item');
		if (ritmGR.get(current.sys_id)) {
			mrvs = ritmGR.variables.book_details; //multi row variable set info
			rowCount = mrvs.getRowCount();
		
		if(rowCount >= 0){
			
			template.print('<table border="1px solid black" style="font-family:Arial">');
			template.print( "<tr bgcolor='#ddd'align='center'>" );
			template.print("<td style='text-align:center' colspan='10'><strong>Book Details</strong></td>");
			template.print( "</tr>" );
			
			template.print( "<tr>" );
			template.print( "<td><center><b>Type</b></center></td>" );
			template.print( "<td><center><b>Title </b></center></td>" );
			template.print( "<td><center><b>Subtitle</b></center></td>" );
			template.print( "<td><center><b>Author / Editor</b></center></td>" );
			template.print( "<td><center><b>Year of Published</b></center></td>" );
			template.print( "<td><center><b>International Standard Book Number</b></center></td>" );
			template.print( "<td><center><b>Publisher</b></center></td>" );
			template.print( "<td><center><b>URL</b></center></td>" );
			template.print( "<td><center><b>Estimated Price (SGD)</b></center></td>" );
			template.print( "</tr>" );
			
			var mvrs = current.variables.book_details;
			gs.log('Result is '+mvrs);
			var obj = JSON.parse(mvrs);
			
			for (var a=0 ; a < obj.length; a++) {

				template.print( "<tr>" );
				template.print( "<td><center>" +obj[a].type + "</center></td>" );
				template.print( "<td><left>" +obj[a].title + "</left></td>" );
				template.print( "<td><left>" +obj[a].subtitle + "</left></td>" );
				template.print( "<td><left>" +obj[a].author_editor + "</left></td>" );
				template.print( "<td><center>" +obj[a].year_of_published + "</center></td>" );
				template.print( "<td><left>" +obj[a].international_standard_book_number_isbn + "</left></td>" );
				template.print( "<td><left>" +obj[a].publisher + "</left></td>" );
				template.print( "<td><left>" +obj[a].url + "</left></td>" );
				template.print( "<td><center>" +obj[a].estimated_price_sgd + "</center></td>" );
				template.print( "</tr>" );
			}
			template.print('</table>');
			
		}}})(current, template, email, email_action, event);
0 Helpfuls

Go to solution
Harsh Vardhan
Giga Patron
In response to Si Min

‎08-04-2019 07:25 AM

try now and run the code and search the log in log table.

 

(function runMailScript(/* GlideRecord */ current, /* TemplatePrinter */ template,
/* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action,
/* Optional GlideRecord */ event) {
	
	template.print("Summary of Requested items:<br />");
	
	var set = new GlideappVariablePoolQuestionSet();
	
	set.setRequestID(current.getValue('sysapproval'));
	set.load();
	
	var vs = set.getFlatQuestions();
	
	gs.log('VS Size '+vs.size(),'Test MRVS');
	
	for (var i = 0; i < vs.size(); i++) {
		
		if (vs.get(i).getLabel() != '' && vs.get(i).getDisplayValue()!='' && vs.get(i).getDisplayValue()!='false') {
			
			template.space(4);
			template.print(vs.get(i).getLabel() + " = " + vs.get(i).getDisplayValue() + "<br/>");
			
		}
	}
	gs.log('Before mrvs','Test MRVS');
		var mrvs;
		var rowCount;
		var ritmGR = new GlideRecord('sc_req_item');
		if (ritmGR.get(current.sys_id)) {
			//mrvs = ritmGR.variables.book_details; //multi row variable set info
			
			gs.log('Coming inside if ','Test MRVS');
			
			template.print('<table border="1px solid black" style="font-family:Arial">');
			template.print( "<tr bgcolor='#ddd'align='center'>" );
			template.print("<td style='text-align:center' colspan='10'><strong>Book Details</strong></td>");
			template.print( "</tr>" );
			
			template.print( "<tr>" );
			template.print( "<td><center><b>Type</b></center></td>" );
			template.print( "<td><center><b>Title </b></center></td>" );
			template.print( "<td><center><b>Subtitle</b></center></td>" );
			template.print( "<td><center><b>Author / Editor</b></center></td>" );
			template.print( "<td><center><b>Year of Published</b></center></td>" );
			template.print( "<td><center><b>International Standard Book Number</b></center></td>" );
			template.print( "<td><center><b>Publisher</b></center></td>" );
			template.print( "<td><center><b>URL</b></center></td>" );
			template.print( "<td><center><b>Estimated Price (SGD)</b></center></td>" );
			template.print( "</tr>" );
			
			var mvrs = current.variables.book_details;
			gs.log('Result is '+mvrs);
			var obj = JSON.parse(mvrs);
			
			for (var a=0 ; a<obj.length; a++) {
			
			gs.log('Sample Result is'+ obj[a].type,'Test MRVS');

				template.print( "<tr>" );
				template.print( "<td><center>" +obj[a].type + "</center></td>" );
				template.print( "<td><left>" +obj[a].title + "</left></td>" );
				template.print( "<td><left>" +obj[a].subtitle + "</left></td>" );
				template.print( "<td><left>" +obj[a].author_editor + "</left></td>" );
				template.print( "<td><center>" +obj[a].year_of_published + "</center></td>" );
				template.print( "<td><left>" +obj[a].international_standard_book_number_isbn + "</left></td>" );
				template.print( "<td><left>" +obj[a].publisher + "</left></td>" );
				template.print( "<td><left>" +obj[a].url + "</left></td>" );
				template.print( "<td><center>" +obj[a].estimated_price_sgd + "</center></td>" );
				template.print( "</tr>" );
			}
			template.print('</table>');
			
		}}})(current, template, email, email_action, event);

 

 

0 Helpfuls

Go to solution
Si Min
Giga Expert
In response to Harsh Vardhan

‎08-04-2019 07:35 AM

The source is Test MRVS right? find_real_file.png

Preview file
46 KB
Preview file
65 KB
0 Helpfuls

Go to solution
Harsh Vardhan
Giga Patron
In response to Si Min

‎08-04-2019 07:42 AM

yes. 

search for the log message "Result is"

 

 

0 Helpfuls

Go to solution
Si Min
Giga Expert
In response to Harsh Vardhan

‎08-04-2019 07:44 AM

Checked but don't have any. 

It stop at Before mrvs. 

0 Helpfuls