Get Display Value and in mail script

jimpaige · ‎07-17-2016

Hi all,

I'm using this mail script to capture variables for a catalog item to be sent in a notification:

printVars();

function printVars() {

template.print('Catering Request Details\n');

var cv = new GlideRecord('sc_item_option_mtom');

cv.addQuery('request_item', current.sys_id);

cv.addNotNullQuery('sc_item_option.value');

cv.orderBy('sc_item_option.order');

cv.addQuery('sc_item_option.value', '!=', '0');

cv.addQuery('sc_item_option.value', '!=',"false");

cv.query();

while(cv.next()) {

template.print('\n' + cv.sc_item_option.item_option_new.question_text + ':\t' + cv.sc_item_option.value + '');

}

I have a few variables that are type Reference and for these the sys_id is returned. I think need to include a getDisaplayValue condition in the script but not sure where to put, of if that is even the correct approach. Any ideas anyone?

Thanks,

Jimmy

Abhinay Erra · ‎07-17-2016

Here you go

template.print('<b>Catering Request Details</b>'+ "<br/>");

var set = new GlideappVariablePoolQuestionSet();

set.setRequestID(current.sys_id.toString());

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.print(' ' + vs.get(i).getLabel() + " = " + vs.get(i).getDisplayValue() + "<br/>");

       }

}

View solution in original post

jimpaige · ‎07-17-2016

Abhinay,

You are a legend my friend!

Pradeep Sharma · ‎07-17-2016

Hi Jim,

I just saw your response.

Sorry for being late on this one.

jimpaige · ‎07-18-2016

No worries, Pradeep. Thanks for your help.

aji1234 · ‎04-28-2017

You can write a mail script :

var dm = current.sys_domain;

var val = current.state;

var myLabel = Choice(dm,"state",val);

template.print("State: "+myLabel);

function Choice(a,b,c){

var query = 'sys_domain='+a+'^element='+b+'^value='+c;

var gr = new GlideRecord("sys_choice");

gr.addEncodedQuery(query);

gr.query();

if (gr.next()) return gr.label;

}