Hi Ellie,
To clarify, if you want to limit the list of available records, you would call your Script Include from a reference qualifier. Your CCS is attempting to set the value of the reference variable to multiple values which only works with List Collector type variables, so first decide which you really want to do.
In either case, in your Script Include, you are pushing the sys_ids to a simple array, which is not a JSON object, and you don't need to worry about duplicates, so use this simplified approach instead:
while (gr.next()) {
userList.push(gr.sys_id.toString());
}
// Log the response before returning for debugging
gs.info('Returning sys_ids: ' + userList.join(',');
// Return the list
return userList.join(','); // Convert array to string and return it
},
type: 'GetUsersFromCompany'
});
Note that if using this with a reference qualifier which only calls the Script Include, you'll want to change the return:
return 'sys_idIN' + userList.join(','); // Convert array to string and return it
If you change the reference variable to a list collector to set the value, just use setValue with the response.
To limit the available records, your reference qualifier would look like this:
If this is a field on a table/form instead of a variable in a Catalog Item, just use current.ref_contact_person.
Your Script Include doesn't need to be Client callable in this case, but it doesn't hurt to leave the extended object in there. Here's what it would look like to work with the user sys_id passed in from the reference qualifier, along with the above changes:
var GetUsersFromCompany = Class.create();
GetUsersFromCompany.prototype = Object.extendsObject(global.AbstractAjaxProcessor, {
// Define the getList function to get the list of user sys_ids
getList: function(contactPersonSysId) {
gs.info('Script Include - Contact Person sys_id: ' + contactPersonSysId); // Log the contact person sys_id
var userList = [];
// Get the company of the contact person
var userGR = new GlideRecord('sys_user');
if (userGR.get(contactPersonSysId)) {
var contactPersonCompany = userGR.company; // Get the company of the contact person
// Query users in the same company
var gr = new GlideRecord('sys_user');
gr.addQuery('company', contactPersonCompany);
gr.addQuery('active', true); // Filter only active users
gr.query();
// Collect sys_ids of users in the same company
while (gr.next()) {
userList.push(gr.sys_id.toString()); // Add the sys_id of the user to the list
}
}
}
// Log the response before returning for debugging
gs.info('Returning sys_ids: ' + userList.join(',')); // Logs the array string of sys_ids
// Return the list as a JSON string
return 'sys_idIN' + userList.join(','); // Convert to array string and return it
},
type: 'GetUsersFromCompany'
});
