Thank you for the information! I believe I'm heading in the right direction and need a little bit more troubleshooting.
First, here are the code snippets of the script includes attached from above.
//getGroupMembers
//Get the current user's groups and the member's of those groups.
// var people = getGroupMembers();
// gs.log("people: " + people, "nf_DA_script_include");
function getGroupMembers(){
var grps = getMyGroupsAdvanced(0);
var mbrs = [];
gs.log("Current User sysid" + gs.getUserID(), "nf_DA_script_include");
gs.log("grps: " + grps, "nf_DA_script_include");
gs.log("length " + grps.length, "nf_DA_script_include");
for (var i = 0; i < grps.length; i++) { //for each group obtain the group members
// gs.log("Group " + i + " is: " + grps[i], 'nf_DA_script_include');
var gr = new GlideRecord('sys_user_grmember');
gr.addQuery('group', grps[i]);
gr.query();
// gs.log("length of group members: " + gr.getRowCount(), "nf_DA_script_include");
while (gr.next()) {
// gs.log("Member Name: " + gr.user, "nf_DA_script_include");
mbrs.push(gr.user.toString());
}
}
// gs.log("All Members Array (with dups): " + mbrs, "nf_DA_script_include");
//Remove any duplicates from group string
mbrs = checkDuplicates(mbrs);
// gs.log("All Members Array (with out dups): " + mbrs, "nf_DA_script_include");
return mbrs;
}
function checkDuplicates(a){
//Check all values in the incoming array and eliminate any duplicates
var r = [];
o:for(var i = 0, n = a.length; i < n; i++){
for(var x = 0, y = r.length; x < y; x++){
if(r[x]==a[i]){
continue o;
}
}
r[r.length] = a[i];
}
return r;
}//getMyGroupsAdvanced
//From SN Guru
//https://servicenowguru.com/scripting/script-includes-scripting/advanced-getmygroups-function/
//Maximum number of levels to search for groups.
//No maxDepth returns groups where user is a group member (Same as 'getMyGroups' function)
//maxDepth of 0 returns groups where user is a group member or a manager
//maxDepth greater than 0 returns groups where user is a group member or a manager PLUS all child groups up to 'maxDepth' levels deep
var maxDepth;
var groupArr = [];
var finalArr = [];
function getMyGroupsAdvanced(inputDepth){
//Set maxDepth to the given depth
maxDepth = inputDepth;
//Get the sys_id of the current user
var uID = gs.getUserID();
//Get all active groups where user is a member
var grmember = new GlideRecord('sys_user_grmember');
grmember.addQuery('user', uID);
grmember.addQuery('group.active', true);
grmember.query();
while(grmember.next()){
//Push the group sys_id values into the group array
groupArr.push(grmember.group.toString());
}
//If a maxDepth value is given then include groups where user is a manager
if(maxDepth >= 0){
//Get all active groups where user is a manager
var grman = new GlideRecord('sys_user_group');
grman.addQuery('manager', uID);
grman.addQuery('active', true);
grman.query();
while(grman.next()){
//Push the group sys_id values into the group array
groupArr.push(grman.sys_id.toString());
}
}
//Remove any duplicates from group string
groupArr = checkDuplicates(groupArr);
//If maxDepth > 0 then check for child groups
if(maxDepth > 0){
//Iterate through all of the groups and return all children for each group
for(var x in groupArr){
//Only process if group sys_id is not already in the returned array
if(finalArr.length == 0 || finalArr.join().indexOf(groupArr[x]) == -1){
finalArr.push(groupArr[x]);
}
recursChildGroups(groupArr[x], 0);
}
}
//If we didn't check for child groups then just return the group array
else{
finalArr = groupArr;
}
//Return the array of group IDs
return finalArr;
}
function recursChildGroups(group, depth){
//Increase the current depth
depth++;
//If we have gone more than the allowed depth then abort for the given group
if(depth > maxDepth){
//('Possible recursive group loop with group ' + group);
return null;
}
//Make sure that we have a valid group ID
if(group){
if(group.toString().length == 0){
return null;
}
//Query for the active child groups of this group
var rec = new GlideRecord('sys_user_group');
rec.addQuery('parent', group);
rec.addQuery('active', true);
rec.query();
while(rec.next()){
//If the group has already been added then do not add again
if(finalArr.join().indexOf(rec.sys_id.toString()) > -1){
continue;
}
//Add the group to the final array
finalArr.push(rec.sys_id.toString());
//Find the child groups of this group
recursChildGroups(rec.sys_id.toString(),depth);
}
}
return null;
}
function checkDuplicates(a){
//Check all values in the incoming array and eliminate any duplicates
var r = [];
o:for(var i = 0, n = a.length; i < n; i++){
for(var x = 0, y = r.length; x < y; x++){
if(r[x]==a[i]){
continue o;
}
}
r[r.length] = a[i];
}
return r;
}To help verify and troubleshoot, here are screenshots corresponding to your steps above.
4) Data Broker Server Script - this is the same as the getGroupMembers script include.
5) Corresponding ACL for above Data Broker Server Script
7) Added data source - I think this is where I'm doing something wrong? Not entirely sure.
😎 Client State Parameter binding
😎 continued - every time I save this, it empties out the initial value. I believe this is my second problem?
9) The binding of the client state onto the list filter
To try and verify this, I created a request where my user was in the requested for field. The list should at least return this request, but does not.
Thank you again for the information! I feel that this is closer to what I'm trying to accomplish.
Dom
