Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-06-2025 01:18 AM
Hello @Ankur Bawiskar ,
We have used Advanced Ref qualifier for SVP field.
Here's the script include :
var JobGroupMember = Class.create();
JobGroupMember.prototype = Object.extendsObject(global.AbstractAjaxProcessor, {
getMembers: function() {
var users = [];
var groupName = this.getParameter('sysparm_organization');
var gr = new GlideRecordSecure('sys_user_group');
gr.addQuery('name', groupName);
gr.query();
if (gr.next()) {
var groupSysId = gr.sys_id.toString();
var members = new GlideRecordSecure('sys_user_grmember');
members.addQuery('group', groupSysId);
members.query();
while (members.next()) {
var mates = members.user.name.toString();
users.push(mates);
}
return JSON.stringify(users);
}
},
type: 'JobGroupMember'
});
Client script :
function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue == '') {
return;
}
var line = g_form.getValue('organization');
if (line == 'Commercial') {
line = 'Job Request - Commercial VP/SVP';
} else if (line == 'Finance') {
line = 'Job Request - Finance VP/SVP';
}else if (line == 'Graphic Solutions') {
line = 'Job Request - Graphic Solutions VP/SVP';
}else if (line == 'HR') {
line = 'Job Request - HR VP/SVP';
}
var ga = new GlideAjax('JobGroupMember');
ga.addParam('sysparm_name', "getMembers");
ga.addParam('sysparm_organization', line);
ga.getXMLAnswer(callback);
function callback(response) {
var answer = JSON.parse(response); {
g_form.setValue("svp", answer.join(','));
}
}
}
Thank you.