Hi Brad,
I tried the above but didn't work either.
In my PDI I created a small cat item I am on Xanadu
I logs the correct user sys id, comp sys id and logs the 4 servers the user should see but in the variable all server are listed. I do not understand this at all anymore. The ref variable for ipc_server I tried simple and advanced with and without ref qualifier does this matter?
I have done quite a few of these AJAX calls and they always return the expected values so I am baffled and cannot figure out how to solve this.
SI
function onLoad() {
var reqUserSysId = g_form.getValue('req_for'); // Get the user from the req_for variable
console.log('req_for value: ' + reqUserSysId); // Log the value of req_for
if (reqUserSysId) {
var ga = new GlideAjax('Icptest'); // Call the Script Include 'Icptest'
ga.addParam('sysparm_name', 'getIPCServersForCurrentUser'); // Specify the function to call
ga.addParam('sysparm_req_for', reqUserSysId); // Pass the req_for user sys_id
ga.getXMLAnswer(function(response) {
console.log('Response from server: ' + response); // Log the server response
if (response && response.trim() !== '') {
console.log('Setting ipc_servers field with: ' + response); // Log the value being set
g_form.setValue('ipc_servers', response); // Set the value directly
} else {
console.log('No valid response received, clearing field'); // Log if no valid response
g_form.clearValue('ipc_servers'); // Clear if no valid response
}
});
} else {
console.log('No req_for value found, clearing ipc_servers field'); // Log if no req_for is found
g_form.clearValue('ipc_servers'); // Clear the field if no req_user is found
}
}
var Icptest = Class.create();
Icptest.prototype = Object.extendsObject(global.AbstractAjaxProcessor, {
getIPCServersForCurrentUser: function() {
var req_for = this.getParameter('sysparm_req_for'); // Get the passed req_for user sys_id
if (!req_for) {
gs.warn('No req_for value passed to Script Include.');
return '';
}
gs.info('Starting getIPCServersForCurrentUser for user: ' + req_for); // Log user sys_id
var result = [];
// Get the company of the current user
var userGR = new GlideRecord('sys_user');
if (userGR.get(req_for)) {
var userCompanySysId = userGR.company.sys_id.toString(); // Get user's company sys_id
gs.info('User found: ' + req_for + ', Company: ' + userCompanySysId); // Log user's company
// Query cmdb_ci_server for servers where u_ipc is true and company matches
var serverGR = new GlideRecord('cmdb_ci_server');
serverGR.addQuery('u_ipc', true); // Only IPC servers
serverGR.addQuery('company', userCompanySysId); // Match user's company sys_id
serverGR.query();
// Collect the sys_ids of the matching records
gs.info('Querying cmdb_ci_server for IPC servers in company: ' + userCompanySysId);
while (serverGR.next()) {
gs.info('Found IPC server: ' + serverGR.getValue('sys_id')); // Log each matching sys_id
result.push(serverGR.getValue('sys_id'));
}
} else {
gs.warn('User not found for sys_id: ' + req_for); // Log if the user is not found
}
gs.info('Returning IPC server sys_ids: ' + result.join(',')); // Log final result
return result.join(','); // Return comma-separated sys_ids
},
type: 'Icptest'
});
AJAX
function onLoad() {
var reqUserSysId = g_form.getValue('req_for'); // Get the user from the req_for variable
console.log('req_for value: ' + reqUserSysId); // Log the value of req_for
if (reqUserSysId) {
var ga = new GlideAjax('Icptest'); // Call the Script Include 'Icptest'
ga.addParam('sysparm_name', 'getIPCServersForCurrentUser'); // Specify the function to call
ga.addParam('sysparm_req_for', reqUserSysId); // Pass the req_for user sys_id
ga.getXMLAnswer(function(response) {
console.log('Response from server: ' + response); // Log the server response
if (response && response.trim() !== '') {
console.log('Setting ipc_servers field with: ' + response); // Log the value being set
g_form.setValue('ipc_servers', response); // Set the value directly
} else {
console.log('No valid response received, clearing field'); // Log if no valid response
g_form.clearValue('ipc_servers'); // Clear if no valid response
}
});
} else {
console.log('No req_for value found, clearing ipc_servers field'); // Log if no req_for is found
g_form.clearValue('ipc_servers'); // Clear the field if no req_user is found
}
}
