Trouble deleting record from sys_user_grmember table - info message is only unexpected message.

[Lon Landry4]

Howdy Community, 

I am having touble deleting record from sys_user_grmember table - info message is only unexpected message.

I do not get any error messages.

Info message = type: m2m, name[sys_user_grmember] view[null]

All gs.logs copmplete as expected with sys_id of group member record I am trying to delete.

The current result is a sys_user_grmember record with the user removed but the record is not deleted and still shows in user's groups.

(function executeRule(current, previous /*null when async*/) {
// Add your code here
var groupRecordX = new GlideRecord('sys_user_grmember');
groupRecordX.record = current.sys_id; //get the sys_id of current group member record
gs.log(groupRecordX.record);
groupRecordX.query();
while (groupRecordX.next()){
groupRecordX.deleteRecord(); //Remove the user from TEST group in user's record
gs.log(groupRecordX.record);
return;}
})(current, previous);

Any ideas?

Thanks for your time,

Lon

[Prateek kumar]

Try below:

(function executeRule(current, previous /*null when async*/) {
// Add your code here
var groupRecordX = new GlideRecord('sys_user_grmember');
groupRecordX.record = current.sys_id; //get the sys_id of current group member record
gs.log(groupRecordX.record);
groupRecordX.addQuery('sys_id', current.sys_id);
groupRecordX.query();
while (groupRecordX.next()){
groupRecordX.deleteRecord(); //Remove the user from TEST group in user's record
gs.log(groupRecordX.record);
return;}
})(current, previous);

[Lon Landry4]

Above script resulted in:

[object GlideRecord] is now gs.log message - does not work so far.

I tried below script and about 4 other variations without luck, I am not getting the sys_user_grmember sys_id for the record...

(function executeRule(current, previous /*null when async*/) {
// Add your code here
var groupRecordX = new GlideRecord('sys_user_grmember');
groupRecordX.addQuery(current.sys_id);
groupRecordX.query();
gs.log(groupRecordX);
while (groupRecordX.next()){
groupRecordX.deleteRecord(); //Remove the user from WFD Authorization group in user's record
gs.log(groupRecordX);
return;}
})(current, previous);

[Prateek kumar]

This seems like a business rule, on which table is your BR configured.

[Lon Landry4]

Good question, a custom table.