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");

               }
           }
   }

[harishdasari]

I think  GlideappVariablePoolQuestionSet()  will not work in scoped application... because I am using this email script in HR application scope.

Am I correct ?

Thank you.

[Ankur Bawiskar]

Hi Harish,

Correct, it won't work in scoped app

following error I got

Evaluator: java.lang.SecurityException: GlideappVariablePoolQuestionSet is not allowed in scoped applications

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[harishdasari]

Thank you Srivatsava and Ankur.

[Ankur Bawiskar]

Hi Harish,

Could you also mark the answer as correct and helpful. Thanks in advance.

Regards

Ankur

[vinothkumar · Accepted solution]

Harish,

You can try something like this and it will work

var gift = new GlideRecord('sn_hr_core_case');

gift.addQuery('sys_id', current.sys_id);

gift.query();

if(gift.next()) {

template.print(" Requestor" +  m.variables.variable_name);

}