Server side script to retrieve user Id, user email address,User's manager's name from the watch list in the incident table

[vipultiwar01]

Server side script to retrieve user Id, user email address,User's manager's name from the watch list in the incident table.

[saprem_d]

Hi,

please use below logic

var wl = current.watchlistField

var userID = '';

var email = '';

var manager = '';

var sd = new GlideRecord('sys_user');

if(sd.get()) {

userID = sd.user_name

email = sd.email

manager = sd.manager

}

[Sharique Azim · Accepted solution]

Hi Vipul,

Remember watch list is an advanced form of reference field.

SO,

vat lst= [];

var str=[];

var inc= new GlideRecord('incident');

inc.get('number','Incident number');

list.push(inc.getValue('watch_list')); //storing the values of watch list in my array

//next query user's table

for(var i=0; i< lst.length; i++){

var usr= new GlideRecord('sys_user');

usr.get('sys_id',lst[i]);

//retrieving user Id, user email address,User's manager's name

str.push('User ID='+usr.getValue('user_id') +'Email='+usr.getValue('email')+'Manager='+usr.getValue('manager'));

}

str.join('\n'); // this now has all the field values.

Thanks.