Hi Pradeep,



Thanks, I got this working. I had to query the parent group first. Regarding the group_sysid, I should have been more clear. The parent group will be dynamic based on the department being passed.



function getDepartmentGroups(deptID){


        var grpList = [];


        var deptGR = new GlideRecord('cmn_deprtment');


        if(deptGR.get(deptID)){


                  var deptName = DeptGR.name.replace(',', '');//Some of the departments contain commas, but the groups do not


                  var parentGroup = new GlideRecord('sys_user_group');


                  parentGroup.addQuery('name', deptName + '_SuggestedDLs');


                  parentGroup.query();


                  while(parentGroup.next()){


                            var grpGR - new GlideRecord('sys_user_group');


                            var grpGR.addQuery('u_parent, 'CONTAINS', parentGroup.sys_id);


                            grpGR.query();


                            while(grpGR.next()){


                                      grpList.push(grpGR.sys_id + '');      


                            }


                  }


        }


        return grpList;


}


View solution in original post