Pulling Variables to Email Notification

Sofija · ‎09-09-2015

Hi All,

I have an email script that pulls variables in an organized manner to an approval email notification. However, it only pulls them if in catalogue item I used a variables set rather than individual variables. For example, if my service catalog item has a variables set of 10 items, email script will pull all of them. However, if I have a catalogue item with 10 variables, it will pull just a few of them. Could anyone be able to help me with this so all variables are pulled no matter if there is a variable set or not?

Here is the email script:

var reqI = new GlideRecord("sc_req_item");
reqI.addQuery("sys_id", current.sysapproval);
reqI.query();
if(reqI.next()) {
new Var2Desc().printVariables(reqI,function(){}, true);

}

Here is script include:

var Var2Desc = Class.create();
Var2Desc.prototype = {
initialize: function() {
/* map: element vs internal field type */
this.UI_PAGE = 15,
this.MASKED = 25,
this.DATE = 9,
this.NUMERIC_SCALE = 4,
this.CHECKBOX = 7,
this.MULTIPLE_CHOICE = 3,
this.DATE_TIME = 10,
this.CONTAINER_END = 20,
this.LABEL = 11,
this.WIDE_SINGLE_LINE_TEXT = 16,
this.YES_NO = 1,
this.HTML = 23,
this.SELECT_BOX = 5,
this.MACRO = 14,
this.REFERENCE = 8,
this.LOOKUP_MULTIPLE_CHOICE = 22,
this.LIST_COLLECTOR = 21,
this.MULTI_LINE_TEXT = 2,
this.SINGLE_LINE_TEXT = 6,
this.MACRO_WITH_LABEL = 17,
this.LOOKUP_SELECT_BOX = 18,
this.SPLIT = 24,
/* this is a list of elements that will be ignored */
this.IGNORE = [this.UI_PAGE, this.CONTAINER_END, this.HTML, this.MACRO,
this.MACRO_WITH_LABEL, this.SPLIT, this.LABEL];

},

/*
* ritm GlideRecord object
* func javascript function to customize conditions
* to skip centain variables values
* noBlanks true|false to avoid empty variable's value
*/
printVariables: function(ritm, func, noBlanks) {
gs.print("here in script");
var d = '';
var noBlanks = noBlanks || false;
var vars = this._getVariablesSorted(ritm);

/* loop the variables */
for(var i =0; i < vars.length; i++) {
var o = vars[i];
var type = o.type;
var label = o.label;
/* ignore list of types */
if(this._isIgnored(o.type))
continue;

/* if custom function is provided, execute custom conditions */
if(func && typeof func == 'function') {
if(func.call(this,o)) continue;
}

template.print(" "+label+"");
template.print(" "+v+"");
}

},

_getVariablesSorted: function(ritm) {
var vars = [];
for(var variableName in ritm.variables) {
/* GlideObject */
var go = ritm.variables[variableName].getGlideObject();
/* Question */
var question = go.getQuestion();
/* Label */
var label = go.getQuestion().getLabel();
/* Type (numeric value) */
var type = new Number(go.getType());
/* Order (numeric value) */
var order = new Number(go.getQuestion().getOrder());
/* creates an Object */
var o = {
'name': variableName,
'label': label,
'value': ritm.variables[variableName],
'order': order,
'type': type
};
vars.push(o);
}
/* return the variables in order as per the form */
return this._quicksort(vars);
},

/* quick sort algorithm */
_quicksort: function(arr) {
if (arr.length === 0) {
return [];
}
var left = [];
var right = [];
var pivot = arr[0];
for (var i = 1; i < arr.length; i++) {
/* compare order from object */
if (arr[i].order < pivot.order) {
left.push(arr[i]);
} else {
right.push(arr[i]);
}
}
return this._quicksort(left).concat(pivot, this._quicksort(right));
},

/* check if the given field type should be ignored */
_isIgnored: function(type) {
for(i=0; i < this.IGNORE.length; i++)
if( this.IGNORE[i] == type)
return true;
return false;
},

type: 'Var2Desc'
}

Kind Regards,

Kamile

Sofija · ‎12-03-2015

For those still looking for solution to this here email script that does the work beautifully:

// Get Requested Item

var reqitem = new GlideRecord('sc_req_item');

reqitem.addQuery("sys_id", current.sysapproval);

reqitem.query();

while(reqitem.next()) {

// Get Owned Variables for Requested Item and sort by Order

var ownvar = new GlideRecord('sc_item_option_mtom');

ownvar.addQuery('request_item.number', reqitem.number);

ownvar.addQuery('sc_item_option.value','!=','');

ownvar.orderBy('sc_item_option.order');

ownvar.query();

while(ownvar.next()) {

// Add Question, Answer and Order into notification mail

// Set variable v to variable name

var field = ownvar.sc_item_option.item_option_new;

var fieldValue = ownvar.sc_item_option.item_option_new.name;

// Print variable name

template.print( '' + field.getDisplayValue() + '' + '\n');

// Print Display Value for each variable in Requested Item

template.print( reqitem.variables[fieldValue].getDisplayValue() + "\n\n");

}

View solution in original post

srinivasthelu · ‎09-09-2015

Hi Kamile,

Have you tried changing the parameter?

new Var2Desc().printVariables(reqI,function(){}, true); // change this to new Var2Desc().printVariables(reqI,function(){}, false);

Thanks

Srinivas

Sofija · ‎09-09-2015

I did not try this, but as Deepak mentioned below this parameter pulls blank variables as well, and I dont want them to be pulled. The issue is that variables that have values and been entered do not get pulled unless they were created as a varibale set (as least from troubleshooting I did this was the only correlation).

Deepak Ingale1 · ‎09-09-2015

Another question.

Information being pulled out is of 'Variable set' and issue with other variables?

Also, is it the catalog item or Record Producer?

Sofija · ‎09-10-2015

I been to get information pulled out from both variables and variable sets. Currently it pulls from both, however, from variables sets it pulls all the info (excluding blanks) and from variables it pulls only 2-6 first variables but not all of them (excluding blanks).

I am using catalogue item.