Remove list of users from list collector from a specified group

[jakelaux]

Hello all,

I am trying to collect a list of users in a service form's list collector and to remove said users from the group. I am running this script from within the workflow for the service.

The following is the script snippet I am having issues with.

var users =   current.variables.users_remove.toString().split(',');

    for(var i=0; i<users.length; i++){

          var gr = new GlideRecord('sys_user_grmember');

          gr.addQuery('group', current.variables.group);

          //gs.log("user " + i + ": "+ users[i]);

          //gr.addQuery('user', users[i]);

          gr.query();

          //gs.log("gr.next: " + gr.next());

          if(gr.next()){ //while there are records in the recordset

                  var temp = gr.deleteRecord();

                  // gs.log("TEMP: " + temp);

            }

    }

The issue I am currently having is that gr.next() is returning false even though I can log the list of users from the group. If anyone could help me out with this I would be quite appreciative.

Thanks,

Jake

[jakelaux]

Here is my latest version of the code:

function deleteMultipleUsers() {

  var users = current.variables.users_remove.toString().split(',');

  for(var i=0; i<users.length; i++){

  var gr = new GlideRecord('sys_user_grmember');

  gr.addQuery('group', current.variables.group);

  gr.addQuery('user', users[i]);

  gr.query();

  if(gr.next()){

  gr.deleteRecord();

  }

  }

}

deleteMultipleUsers();

Thanks for taking a look at this for me!

- Jake

[saritha9]

Hello Jacob,

Is it removing any users from the group?

Try to log users and group values.

[jakelaux]

If I log the users I get a sysId for each user, so I don't believe it's a problem with obtaining and using the list of the users, however, my query is still failing for some reason.

[jakelaux]

The result of the query seems to be unidentified and thus the result of next is then false. Do you have any idea why the result to the query might be unidentified?

Thanks,

-Jake

[saritha9]

Are you getting the group correctly? Add a log for group. Are the users included in the group which is there on the current record?