I am not sure if I am on the right track here. I am trying to search the user table and if some values are true I need to look up in a new table where the u_c_level value is true and only return those records. I am not sure how to look up the records and only return the ones needed.. Glide query to the table ? and how would i return the result to the list.
var GetUserAttributeAjax = Class.create();
GetUserAttributeAjax.prototype = {
initialize: function(GetUserAttributeAjax) {
var usr=current.variables.usrName;
var gr = new GlideRecord('sys_user');
gr.addQuery('user_name',usr);
gr.query();
if (usr.u_ceo == true || usr.u_cfo== true ){
//return records to choice list from u_group table where u_c_level = true
}
else { //return other records where u_c_level false
}
},
