Email script to show variables visible on summary

[Rajesh Mushke]

Hi Team,

we have an email notification when an item is submitted, here we need to show variables visible on summary.

can any one suggest me how to show variables visible on summary using email script.

[Chuck Tomasi · Accepted solution]

You can use this code in a mail script to print variables. This one assumes the message is on the sysapproval_approver table and gets the variables from the record pointed to by the sysapproval table.

printVars();

function printVars(){

      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() != '') {

                      template.print('       ' +   vs.get(i).getLabel() + " = " + vs.get(i).getDisplayValue() + "\n");

              }

      }

}

[Rajesh Mushke]

thank you for the response chuck ,

But in my case i have to include this script in message its self because we were translating to few languages....

Do you have any idea how to call a mail script in message( table name: sys_ui_message) ?

[Chuck Tomasi]

In the server side script, you use gs.getMessage() to get translations of strings.

The getLabel() method in this is already doing label translations for you.

[Alexander Kosak]

ctomasi I was looking for the documentation of GlideappVariablePoolQuestionSet api and did not find any.

Does it mean, that this is not documented api and can be used only at one's own risk?