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.

Don't show Check box variables with value false in email notification

RudhraKAM
Tera Guru

‎09-24-2024 09:17 AM - edited ‎09-24-2024 11:13 AM

We have a notification on sysapproval ,when a request is created we will be sending all the variables on catalog item but we have couple of items where we have 50 checkboxes , If user select only 1 check box  in the notification for approval all other 50 fields are displayed , is there a way to show only the selected checkbox instead of showing all check box ?

 

below is the mail script 

 

var classtype = current.sysapproval.sys_class_name;
if (classtype == 'sc_req_item') {
	
	var gr = new GlideRecord('sc_req_item');
	if (gr.get('sys_id', current.sysapproval)) {
		template.print("<b>Title</b>: " + gr.short_description + "<br />");
		template.print("<b>Requested for</b>: " + gr.request.requested_for.getDisplayValue() + "<br />");
		
		template.print("<b>Options:</b><br />");
		
		var varown = new GlideRecord('sc_item_option_mtom');
		varown.addQuery("request_item", gr.sys_id.toString());
		varown.query();
		while (varown.next()){
			var visible = varown.sc_item_option.item_option_new.visible_summary;
			var question = GlideappQuestion.getQuestion(varown.sc_item_option.item_option_new);
			question.setValue(varown.sc_item_option.value);
			if (question.getLabel() != "" && question.getDisplayValue() != "" && visible == true){
				template.space(4);
				template.print('     ' +  question.getLabel() + " = " + question.getDisplayValue() + "\n");
			}
		}
		
		
	}
} else {
	template.print("<p></p>Requested items:\n");
	
			var gr = new GlideRecord("sc_req_item");
		gr.addQuery("request", current.sysapproval.sys_id);
		gr.query();
		while(gr.next()) {
			template.print("<b>Title</b>: " + gr.short_description + "<br />");
			template.print("<b>Requested for</b>: " + gr.request.requested_for.getDisplayValue() + "<br />");
			
			template.print("<b>Options:</b><br />");
			
			var varown = new GlideRecord('sc_item_option_mtom');
			varown.addQuery("request_item", gr.sys_id.toString());
			varown.query();
			while (varown.next()){
				var visible = varown.sc_item_option.item_option_new.visible_summary;
				var question = GlideappQuestion.getQuestion(varown.sc_item_option.item_option_new);
				question.setValue(varown.sc_item_option.value);
				if (question.getLabel() != "" && question.getDisplayValue() != "" && visible == true){
					template.space(4);
					template.print('     ' +  question.getLabel() + " = " + question.getDisplayValue() + "\n");
				}
			}
			
		}
	}

 

0 Helpfuls
  • 698 Views
4 REPLIES 4

amaradiswamy
Kilo Sage

‎09-24-2024 12:38 PM

Hi @RudhraKAM 

 

Replace your logic where you are querying sc_item_option_mtom with below

(function runMailScript(current, template, email, email_action, event) {

var ritmSysId = current.sys_id;
var set = new GlideappVariablePoolQuestionSet();
set.setRequestID(ritmSysId);
set.load();
var vs = set.getFlatQuestions();

for (var i=0; i < vs.size(); i++) {

var label = vs.get(i).getLabel();

var variableName = vs.get(i).getName();

var variableValue = vs.get(i).getDisplayValue();

if(label !='' && variableName !='' && variableValue.toString() == 'true')

template.print(label + ' : ' + variableValue);

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

RudhraKAM
Tera Guru
In response to amaradiswamy

‎09-25-2024 10:00 AM - edited ‎09-25-2024 10:00 AM 

var classtype = current.sysapproval.sys_class_name;
if (classtype == 'sc_req_item') {

    var gr = new GlideRecord('sc_req_item');
    if (gr.get('sys_id', current.sysapproval)) {
        template.print("<b>Title</b>: " + gr.short_description + "<br />");
        template.print("<b>Requested for</b>: " + gr.request.requested_for.getDisplayValue() + "<br />");

        template.print("<b>Options:</b><br />");

        var varown = new GlideRecord('sc_item_option_mtom');
        varown.addQuery("request_item", gr.sys_id.toString());
        varown.query();
        while (varown.next()) {
            var visible = varown.sc_item_option.item_option_new.visible_summary;
            var question = GlideappQuestion.getQuestion(varown.sc_item_option.item_option_new);
            question.setValue(varown.sc_item_option.value);
            if (question.getDisplayValue() != false && question.getDisplayValue() != "" && visible == true) {
                template.space(4);
                template.print('     ' + question.getLabel() + " = " + question.getDisplayValue() + "\n");
            }
        }


    }
} else {
    template.print("<p></p>Requested items:\n");

    var gr = new GlideRecord("sc_req_item");
    gr.addQuery("request", current.sysapproval.sys_id);
    gr.query();
    while (gr.next()) {
        template.print("<b>Title</b>: " + gr.short_description + "<br />");
        template.print("<b>Requested for</b>: " + gr.request.requested_for.getDisplayValue() + "<br />");

        template.print("<b>Options:</b><br />");

        // 			var varown = new GlideRecord('sc_item_option_mtom');
        // 			varown.addQuery("request_item", gr.sys_id.toString());
        // 			varown.query();
        // 			while (varown.next()){
        // 				var visible = varown.sc_item_option.item_option_new.visible_summary;
        // 				var question = GlideappQuestion.getQuestion(varown.sc_item_option.item_option_new);
        // 				question.setValue(varown.sc_item_option.value);
        // if (question.getDisplayValue() != false && question.getDisplayValue() != "" && visible == true ){
        // 					template.space(4);
        // 					template.print('     ' +  question.getLabel() + " = " + question.getDisplayValue() + "\n");
        // 				}
        // 			}

        var ritmSysId = current.sys_id;
        var set = new GlideappVariablePoolQuestionSet();
        set.setRequestID(ritmSysId);
        set.load();
        var vs = set.getFlatQuestions();

        for (var i = 0; i < vs.size(); i++) {

            var label = vs.get(i).getLabel();

            var variableName = vs.get(i).getName();

            var variableValue = vs.get(i).getDisplayValue();

            if (label != '' && variableName != '' && variableValue.toString() == 'true')

                template.print(label + ' : ' + variableValue);

        }
    }}

 

 

Updated as above but still not working

0 Helpfuls

amaradiswamy
Kilo Sage
In response to RudhraKAM

‎09-27-2024 02:23 AM

Please try with the below:

 

 var classtype = current.sysapproval.sys_class_name;
    if (classtype == 'sc_req_item') {
template.print("<b>Title</b>: " + current.sysapproval.short_description + "<br />");
		template.print("<b>Requested for</b>: " + current.sysapproval.request.requested_for.getDisplayValue() + "<br />");
		
		template.print("<b>Options:</b><br />");
        var ritmSysId = current.sys_id;
        var set = new GlideappVariablePoolQuestionSet();
        set.setRequestID(ritmSysId);
        set.load();
        var vs = set.getFlatQuestions();

        for (var i = 0; i < vs.size(); i++) {

            var label = vs.get(i).getLabel();

            var variableName = vs.get(i).getName();

            var variableValue = vs.get(i).getDisplayValue();

            if (label != '' && variableName != '' && variableValue.toString() != 'false')

                template.print(label + ' : ' + variableValue+'<br />');
        }


    } else {
        template.print("<p></p>Requested items:\n");
 template.print("<b>Title</b>: " + current.sysapproval.short_description + "<br />");
            template.print("<b>Requested for</b>: " + current.sysapproval.requested_for.getDisplayValue() + "<br />");

            template.print("<b>Options:</b><br />");
        var gr = new GlideRecord("sc_req_item");
        gr.addQuery("request", current.getValue('sysapproval'));
        gr.query();
        while (gr.next()) {
            var ritmSysId = gr.getValue('sys_id');
            var set = new GlideappVariablePoolQuestionSet();
            set.setRequestID(ritmSysId);
            set.load();
			template.print('Inside while')
            var vs = set.getFlatQuestions();

            for (var i = 0; i < vs.size(); i++) {

                var label = vs.get(i).getLabel();

                var variableName = vs.get(i).getName();

                var variableValue = vs.get(i).getDisplayValue();

                if (label != '' && variableName != '' && variableValue.toString() != 'false')

                    template.print(label + ' : ' + variableValue+'<br />');
            }
           

            

        }
    }
0 Helpfuls

RudhraKAM
Tera Guru

‎09-26-2024 12:50 PM

can some one help me with this ?

0 Helpfuls