Is this possible to filter the field of reference sys_user into same Region of Requested For ?
Unfortunately this ain't work.
Sample Script:
Script Include:
var UserLocationFilter = Class.create();
UserLocationFilter.prototype = {
initialize: function() {
},
getUsersByLocation: function(userId) {
var userRecord = new GlideRecord('sys_user');
if (userRecord.get(userId)) {
var userLocation = userRecord.getValue('location');
var parentLocation = new GlideRecord('cmn_location');
if (parentLocation.get(userLocation)) {
var grandParentLocation = parentLocation.getValue('parent');
if (grandParentLocation) {
var grandParent = new GlideRecord('cmn_location');
if (grandParent.get(grandParentLocation)) {
var grandParentParentLocation = grandParent.getValue('parent');
if (grandParentParentLocation) {
var users = new GlideRecord('sys_user');
users.addQuery('location.parent.parent', grandParentParentLocation);
users.query();
var userList = [];
while (users.next()) {
userList.push(users.sys_id.toString());
}
return userList.join(',');
}
}
}
}
}
return '';
},
type: 'UserLocationFilter'
};
On-Change
function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue === '') {
return;
}
var requestedFor = newValue;
var ga = new GlideAjax('UserLocationFilter');
ga.addParam('sysparm_name', 'getUsersByLocation');
ga.addParam('sysparm_user_id', requestedFor);
ga.getXMLAnswer(function(response) {
var userList = response.split(',');
var filterCondition = 'sys_idIN' + userList.join(',');
g_form.setValue('variable_name', filterCondition);
});
