how to get list of all assets in a catalog variable

niharikayb · ‎10-17-2016

Hi ,

I have a catalog item where we have 2 variables

requested for (reference field of user table)

serial number (reference field of asset table)

Based on the selection of 'requested for', i need to get all the assets assigned to him/her in the lookup field of 'serial number'

Please help me out.

Thanks in Advance

tanumoy · ‎10-18-2016

Script Include:

Name: getAssignedTo

Client Callable: False

Code:

var getAssignedTo = Class.create();

getAssignedTo.prototype = {

initialize: function() {

},

assigned:function() {

var gp = ' ';

var a = current.variables.requested_for;

if(!a)

return;

var grp = new GlideRecord('alm_hardware');

grp.addQuery('assigned_to', a);

grp.query();

while(grp.next()) {

if (gp.length > 0) {

gp += (',' + grp.sys_id);

}

else {

gp = grp.sys_id;

}

return 'sys_idIN' + gp;

},

}

Advance reference qualifier: javascript:new getAssignedTo().assigned()

Note: Please provide the correct variable names and table names.

niharikayb · ‎10-19-2016

Script include : International

variables --

request_for

serial_number

tanumoy · ‎10-19-2016

There is a mistake in the reference qualifier. Provide javascript: new International().assigned() in the Advance reference qualifier.

niharikayb · ‎10-19-2016

Yes.Got to know that..Thank you so much paul.