How to delete the role based on the condition

[Atik]

Hello Experts,

I have a requirement where there is a field Position on the user table and its choice field and choices are 'Non-Agent' and 'Agent' if 'Non-Agent' then I have to remove the role.

I am trying by background script but not getting the expected result

Please help me with this.

var user = new GlideRecord('sys_user');

user.addQuery('u_position','non_agent');

user.query();

while (user.next()) {

    var hasRole = new GlideRecord('sys_user_has_role');

    hasRole.addQuery('user', user.sys_id);

    hasRole.addQuery('user.role', 'itil');

    hasRole.query();

    if (hasRole.next()) {

    hasRole.deleteRecord;

    }

}

Thanks in advance, atik.

[Voona Rohila · Accepted solution]

Hi @Atik 

Logic is correct, The syntax for delete record method is - hasRole.deleteRecord();

[Voona Rohila · Accepted solution]

Hi @Atik 

Logic is correct, The syntax for delete record method is - hasRole.deleteRecord();

[Voona Rohila · Accepted solution]

You can also try this way without querying the user table.

     var hasRole = new GlideRecord('sys_user_has_role');
    hasRole.addQuery('user.u_position', 'non_agent');
    hasRole.addQuery('user.role', 'itil');
    hasRole.query();
    if (hasRole.next()) {
    hasRole.deleteRecord();
    }

[Atik]

Hey, @Voona Rohila  thanks it worked