add caller of the incident to the group being selected in the assignment group field on insert

[spectura77]

I have created a before business rule and  ,insert as true and used the following script ,but i am not getting the results,please adivce 

(function executeRule(current, previous /*null when async*/ ) {
if (current.operation() == 'insert') {
var assignmentGroup = current.assignment_group;
var caller = current.caller;
if (assignmentGroup && caller) {
var group = new GlideRecord('sys_user_group');
if (group.get(assignmentGroup)) {
group.addMember(caller);
}
}
}
})(current, previous);

[Vishal Birajdar · Accepted solution]

Hi @spectura77 

Can you try below code :

/*1. Get values from current Incident form */
var caller = current.getValue('caller_id');
var group  = current.getValue('assignment_group');

/*2. glide record on sys_user_grmember table */
var grMem = new GlideRecord('sys_user_grmember');
grMem.addEncodedQuery('group=' + group +'^user=' + caller);
grMem.query();
if(!grMem.next()){

/*3. Add user to group */   
var grAddMem = new GlideRecord('sys_user_grmember');
grAddMem.initialize();
grAddMem.setValue('group',group);   //group
grAddMem.setValue('user',caller);  //caller
grAddMem.insert();

} else {
   gs.log("User already a member of group"); 
}

[Alka_Chaudhary]

Hello @spectura77 ,

You can create a on insert business rule.

To add user in group, you have to glide 'sys_user_grmember' table.  Also, have to check if user already exist in the group don't add them. 

Please try the below script:

(function executeRule(current, previous /*null when async*/ ) {

    // Add your code here
    var flag = false;
    var caller = current.caller_id;
    var group = current.assignment_group;
    var gr = new GlideRecord('sys_user_grmember');
    gr.addQuery('group', group);
    gr.query();
    while (gr.next()) {
        if (gr.user == caller) {
            flag = true;
        }
    }

    if (flag == false) {
        gr.initialize();
        gr.user = caller;
        gr.group = group;
        gr.insert();
    }
})(current, previous);

If this response clears up your doubt, kindly flag it as both helpful and correct.

Thanks,

Alka

[spectura77]

Hi @Alka_Chaudhary thank you for the response , I have tried this script but still not getting the result 

[Alka_Chaudhary]

Hello @spectura77 ,

On which table you are creating the business rule and what is the when to run condition?

Please share the screenshot of the script that you wrote.

[spectura77]

Hi @Alka_Chaudhary screen shot of the business rule and the script 

Thanks