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("<br>"+label+"</br>");
template.print("<br>"+v+"</br>");
}

},

_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( '<b>' + field.getDisplayValue() + '</b>' + '\n');

// Print Display Value for each variable in Requested Item

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

}

View solution in original post

Sofija · ‎09-15-2015

Eureka patch 11. I'll try your's now - I see some differences to the one I have..

Deepak Ingale1 · ‎09-15-2015

I had bit of an issue on Eureka for this one.

Original script line no 71 was causing an error to me initially, it was working OK on Fuji though

I commented out that part and then made changes to subsequent two lines. It worked perfect for me then

Sofija · ‎09-15-2015

I will tryo to use the script as you provided it first I hope it will work...

I am missing some script on line 80 through? Would you be so kind and copy that line over so I know I am not missing anything?

Deepak Ingale1 · ‎09-15-2015

Hi Kamile,

You can use the original line no 80 if you want

d+=label+": "+v

I have used below one to have a styling for variable values and their associated lables via HTML tags.

d = d+ '<div><div id="LabelVar"> ' +'<b>'+label+'</b>'+": "+'</div>'+'</div>'+v +'' +'\n';

Sofija · ‎09-15-2015

I keep getting parse error for your styled line...