Get Variables and it's from Record Producer to email notification script

[harishdasari]

Hi,

I have created a email script, which needs to get the variables and it's values from record producer. After record producer is submitted then it will create a record on sn_hr_core_case(HR case) table.

I have created the email script for it, but I am not exactly sure how to get the values.

any can please help how can I accomplish this requirement.

Thank you.

Here is the below script I have tried, but it is NOT WORKING.

var gift = new GlideRecord('sn_hr_core_case');
	gift.addQuery('sys_id', current.document_id);
	gift.query();
	while(gift.next())
		{
			template.print(item.number + ":   " + item.cat_item.getDisplayValue() + "\n");
           template.print("       Item Options:\n");
           var keys = new Array();
           var set = new GlideappVariablePoolQuestionSet();
           set.setRequestID(gift.sys_id);
           set.load();
           var vs = set.getFlatQuestions();
           for (var i=0; i < vs.size(); i++) {
               if(vs.get(i).getLabel() != '') {
                     template.space(4);
                     template.print('         ' +   vs.get(i).getLabel() + " = <span style='color:red'>" + vs.get(i).getDisplayValue() + "</span>\n");

               }
           }
   }

[Ankur Bawiskar]

Hi Vinoth,

The above code won't work since there is an issue in script for glide record object.

Regards

Ankur

[harishdasari]

Thank you Vinoth, it worked.

[VShine]

@harishdasari ,

Can you share your final script? Does it work?