If Manager of the Group has role snc_external than dont grant approver_user role automatically

[Mayuri1711]

Modification for business rule not to grant approver_user role for the manager having snc_external role

[Mayuri1711]

GROUP= 'approval group of managers'
if (current.manager){

        var grpMember = new GlideRecord('sys_user_grmember');

        grpMember.addEncodedQuery('group=edbea634f7d47010ec1c41b84851e06f^user=' + current.manager);

        grpMember.query();

        //gs.addInfoMessage(grpMember.getRowCount());

        if (!grpMember.next()) {

            grpMember.initialize();

            grpMember.group = 'edbea634f7d47010ec1c41b84851e06f';

            grpMember.user = current.manager;

            grpMember.insert();

        }

    }

[Danish Bhairag2 · Accepted solution]

Hi @Mayuri1711 ,

Plz try this code

GROUP= 'approval group of managers'

if (current.manager){

var userRole = new GlideRecord ('sys_user_has_role');

userRole.addQuery('role', 'snc_external');// provide sys I'd of the role or name here

userRole.addQuery('user',current.manager);

userRole.query();

if(userRole.next()){

// Do nothing

}else{

        var grpMember = new GlideRecord('sys_user_grmember');

        grpMember.addEncodedQuery('group=edbea634f7d47010ec1c41b84851e06f^user=' + current.manager);

        grpMember.query();

        //gs.addInfoMessage(grpMember.getRowCount());

        if (!grpMember.next()) {

            grpMember.initialize();

            grpMember.group = 'edbea634f7d47010ec1c41b84851e06f';

            grpMember.user = current.manager;

            grpMember.insert();

        }

    }

}

Thanks,

Danish