I have created one record Producer, which consists of two Variables, one is requestor_name and the other one is meeting_event_location.
The Requestor_name is referring to sys_user table and the meeting_event_location referring to cmn_location table
I want that from user email, i want to fetch the contact account locations, i have written the below script include for that, but its not working. can someone please help me why this script is not working.
accountLocation: function(d)
{
var user = new GlideRecord('sys_user');
user.get(gs.getUserID());
var contact = new GlideRecord('customer_contact');
contact.addQuery('email', user.email);
contact.query();
if(contact.next()){
var cont = contact.getValue('sys_id');
}
var locationlist = [];
var loclist = new GlideRecord('cmn_location');
loclist.addEncodedQuery('account.u_corporate_account', d.cont.account);
loclist.query();
while (loclist.next()) {
locationlist.push(loclist.getValue('sys_id'));
}
return 'sys_idIN' + locationlist;
},
And i am using Advanced reference qualifier in variable (meeting_event_location)
the reference qualifier is = javascript:new sn_customerservice.locationlist().accountLocation(current)
