Figured it out...got some internal help and got the solution by creating an object and then building the array off the key, see script include below. This then removes the duplicates before returning the array to the client script. works perfectly to populate a list collector type field on the form and accommodates for duplicate records on the delegate table.
script include:
var AjaxGetDelegates = Class.create();
AjaxGetDelegates.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getDelegates:function(){
var delList = '';
var tempList = {};
var user = this.getParameter('sysparm_user');
var delegates = new GlideRecord('sys_user_delegate');
delegates.addQuery('user',user);
delegates.query();
while(delegates.next()){
tempList[delegates.delegate] = true;
}
for(var key in tempList) {
delList += key + ',';
}
return delList;
}
});
catalog client script:
function onLoad() {
//look up sys_user_delegate table and populate "my_delegates" field
var user = g_form.getValue('current_user');
var gr = new GlideAjax('AjaxGetDelegates');
gr.addParam('sysparm_name','getDelegates');
gr.addParam('sysparm_user',user);
gr.getXML(setDelegates);
//populate the my_delegates field
function setDelegates(response){
var answer = response.responseXML.documentElement.getAttribute("answer");
//alert('answer is '+answer);
if(answer == '' || answer == undefined){
return false;
}else{
var arr = answer.split('||');
g_form.setValue('my_delegates',arr);
}
}
}
