- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-24-2023 12:13 AM
Hi Team,
On the INC form i want 'assigned to' field pop-up table doesn't show any user until we have 'assignment group' filled. I want to achieve this via Advance reference qual calling script include function.
If above assignment group is empty it should not show users in 'assigned to' field pop table as below:
Thanks in Advance
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-24-2023 04:34 AM
Hi @Vartika Goel .
Follow below steps
1. Create script include and write below code.
var getUser = Class.create();
getUser.prototype = {
initialize: function() {},
getsys: function(group_Name) {
var arr = [];
var grSUG = new GlideRecord('sys_user_grmember');
grSUG.addEncodedQuery("group.sys_id=" + group_Name);
grSUG.query();
while (grSUG.next()) {
arr.push(grSUG.user.toString());
}
return 'sys_idIN' + arr.toString();
},
type: 'getUser'
};
2. Right click on "Assigned to" field and open dictionary override and search for incident table and make following changes.
enable the checkbox and make dependent field empty.
Override dependent
Make sure the check box enabled "Override reference qualifier" and write the code "javascript:new global.getUser().getsys(current.assignment_group);" under "Reference Qualifier" field.
Please change script include and function name as per the naming standard.
and write the code under "reference qualifier".
Please mark the answer correct if it helps.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-24-2023 12:36 AM
Hello Vertika Goel,
You can follow below steps:
1. create a script include and call it in the reference qualifier of 'assigned to' field
2. pass assignmnet group in the qualifier parameter
3. return group members sys_id's as a response from script include (use 'sys_user_grmember' to get the members of a group).
Try above steps and let me know if that works.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-24-2023 12:39 AM
Hi @Vartika Goel,
Create a client callable script include as follows:
var GetGroupMembers = Class.create();
GetGroupMembers.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getUsers:function(groupId){
var userSysId=[];
var grmem=new GlideRecord('sys_user_grmember');
grmem.addQery('group',groupId);
grmem.query();
while(grmem.next()){
userSysId.push(grmem.getValue('user');
}
return 'sys_idIN'+userSysId.toString();
},
type: 'GetGroupMembers'
});
And Call the script include from advanced reference qualifier of assigned to field as javascript: new GetGroupMembers().getUsers(current.assignment_group);
Thanks,
Gopi
Thanks,
Gopi
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-24-2023 12:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-24-2023 01:15 AM
Hi @Vartika Goel ,
Please add " type: 'GetGroupMembers'" after 14th line.
Thanks,
Gopi
Thanks,
Gopi