Haha we really did. I think I confused you Here's a picture of the table I made with a company field and group field. End users will be able to come in and list a company and specify specific groups they want to see if this customer is selected on the current form an end user is on.
I have my script working fine, but I want to add the ability to look at the current form the user is on when they click assignment groups and check if that customer is in this table. If it is, then show the groups associated with that customer in this table and if NOT then go through my script normally how it is now.
I want to implement this functionality in the getGroupsOfType function
var GetGroupsOfTypeRefQual = Class.create();
GetGroupsOfTypeRefQual.prototype = {
initialize: function() {
},
getGroupsOfMyTypeQuery: function() {
var myGroups = this.getMyGroups();
var myGroupsTypes = this.getGroupTypesOfGroups(myGroups);
var groupsOfMyTypes = this.getGroupsOfType(myGroupsTypes);
var encQry = 'sys_idIN' + groupsOfMyTypes.join(",");
return encQry;
},
getMyGroups: function() {
var usr = gs.getUser();
var javaGroupsArray = usr.getMyGroups(); // Returns Java array, need to convert to JS array
var jsGroupsArray = javaGroupsArray.toArray();
var groupsStr = jsGroupsArray.join(",");
return groupsStr;
},
getGroupTypesOfGroups: function(groups) {
var groupTypes = [];
var gaUserGroup = new GlideAggregate('sys_user_group');
gaUserGroup.addAggregate('COUNT', 'type');
gaUserGroup.addQuery('sys_id','IN',groups);
gaUserGroup.query();
while (gaUserGroup.next()) {
groupTypes.push(gaUserGroup.getValue('type'));
}
return groupTypes;
},
getGroupsOfType: function (groupTypes) {
/*look here for customer on the other table to make*/
//all this works fine, but this is where I want to do the current customer query on the new table I made
var groups = [];//show specfic groups by checking if the user is apart of group that has one of thses 2 tags
var isdType = "63600de5db6673c0192a6ac2ca961999"; //ISDagent group type sys_id
var nocType = "9d5089e5db6673c0192a6ac2ca9619bd"; //NOCagent group type sys_id
var index = groupTypes.toString().split(',').indexOf(isdType) > -1;//groupTypes has all of the types pulled from the groups there in and checks to see this type is in the groupTypes array
var index2 = groupTypes.toString().split(',').indexOf(nocType) > -1;
if(index){//show isd agent groups only if they a ISDagent type
var grGroups = new GlideRecord('sys_user_group');
grGroups.addQuery('type','CONTAINS','e797a021dbddbb00192a6ac2ca96198d');//show groups with ISD group type
grGroups.query();
while(grGroups.next()) {
groups.push(grGroups.getValue('sys_id'));
}
return groups;
}
else if(index2){//show noc agent groups only if they a NOCagent type
var grGroups2 = new GlideRecord('sys_user_group');
grGroups2.addQuery('type','CONTAINS','5c330789db2233c0192a6ac2ca9619a9');//show groups with NOC group type
grGroups2.query();
while(grGroups2.next()) {
groups.push(grGroups2.getValue('sys_id'));
}
return groups;
}
else{ //show itsm groups with groups type itsm
var grGroups3 = new GlideRecord('sys_user_group');
grGroups3.addQuery('type','CONTAINS','efa71a776f7f21406ca6687f8e3ee48d');//itsm sys_id
grGroups3.query();
while(grGroups3.next()) {
groups.push(grGroups3.getValue('sys_id'));
}
return groups;
}
},
type: 'GetGroupsOfTypeRefQual'
};
