Position Change is complicated on our end (if it's part of their old job and not their new job, then we need to remove it) so some of this may be a bit confusing. The bottom portion of the script is for adding and in this section "//THE BELOW ADDS THE USER NAME TO THE APP" you'll notice that I pull the list of users for an app and split it, then push the new user to that split list, rejoin the list of users together, then add it back to the column on the table.
(I am looking at your thread you posted now to see if I see anything):
var apps = [];
var apps = workflow.scratchpad.apparraylist;
var length = apps.length;
gs.log("Length: " + length);
//REMOVING USER FROM APPS FOR POSITION CHANGE REQUEST ONLY
if(current.variables.type_of_request == 'position_change') {
var oldapps = [];
var oldapps = workflow.scratchpad.oldapparraylist;
var newapps = [];
var newapps = workflow.scratchpad.newapparraylist;
for(var i=0; i<length;i++){
if(oldapps.contains(apps[i]) && !newapps.contains(apps[i])) {
var oldappname = apps[i].trim();
var requestedfor = current.variables.requested_for;
var rel = new GlideRecord('u_founders_application_list');
rel.addQuery('u_application',oldappname);
rel.query();
if(rel.next()){
var accesslist = rel.u_user_access;
gs.log("Access List: " + accesslist);
var arrUtil = new ArrayUtil();
var accessListArray = rel.u_user_access.toString().split(',');
var arrayposition = arrUtil.indexOf(accessListArray,requestedfor);
gs.log("Position of App: " + arrayposition);
if(arrayposition>=0){
accessListArray.splice(arrayposition,1);
gs.log("Access List Array after Splice: " + accessListArray);
rel.u_user_access = accessListArray.join(',');
rel.update();
}
}
}
}
}
for(var i=0; i<length;i++){
//******************** START ADDING APPS TO USER RECORD RELATED LIST ****************************
//ATTEMPTING TO ADD APPS TO USER RECORD - New Hire, Special Access Request, and Position Change
if(current.variables.type_of_request == 'new_hire' || current.variables.type_of_request == 'access_request' || current.variables.type_of_request == 'position_change'){
var appname = apps[i].trim();
var requestedfor = current.variables.requested_for;
var rel = new GlideRecord('u_founders_application_list');
rel.addQuery('u_application',appname);
rel.query();
if(rel.next()){
var accesslist = rel.u_user_access;
gs.log("Access List: " + accesslist);
if(accesslist.indexOf(requestedfor)>=0){
}else{
//CHECK TO SEE IF THE USER NEEDS TO BE ADDED TO THE APP FOR POSITION CHANGE REQUEST
if(current.variables.type_of_request == 'position_change' && oldapps.contains(apps[i]) && !newapps.contains(apps[i])){
gs.log("APP NOT TO BE ADDED: " + appname);
}else{
//THE BELOW ADDS THE USERS NAME TO THE APP
var accessListArray = rel.u_user_access.toString().split(',');
accessListArray.push(requestedfor);
rel.u_user_access = accessListArray.join(',');
rel.update();
}
}
}
}
//ATTEMPTING TO REMOVE USER FROM APP IN USER RECORD - Remove Special Access
if(current.variables.type_of_request == 'remove_access' || current.variables.type_of_request == 'terminate_access'){
var appname = apps[i].trim();
var requestedfor = current.variables.requested_for;
var rel = new GlideRecord('u_founders_application_list');
rel.addQuery('u_application',appname);
rel.query();
if(rel.next()){
var accesslist = rel.u_user_access;
gs.log("Access List: " + accesslist);
var arrUtil = new ArrayUtil();
var accessListArray = rel.u_user_access.toString().split(',');
var arrayposition = arrUtil.indexOf(accessListArray,requestedfor);
gs.log("Position of App: " + arrayposition);
if(arrayposition>=0){
accessListArray.splice(arrayposition,1);
gs.log("Access List Array after Splice: " + accessListArray);
rel.u_user_access = accessListArray.join(',');
rel.update();
}
}
}
//******************** END ADDING APPS TO USER RECORD RELATED LIST ****************************
}
Please mark this response as correct and/or helpful if it assisted you with your question.
Steven
