Business Rule

[Tomas Linde]

Hello, I need to filter in the database to know if the deactivated user is the manager of another user.

I have this part of the code to filter if it is a manager. This is a small part of a larger code.

var checkManagerGr = new GlideRecord('sys_user');

checkManagerGr.addQuery('manager',previous.manager);

checkManagerGr.addQuery('u_group_management_memeber','true');

checkManagerGr.query();

while (checkManagerGr.next()) {

var nameManager = checkManagerGr.getValue('user_name');

}

I would like to know if it is okay, since it does not execute correctly for me.

[Harish Bainsla · Accepted solution]

var checkManagerGr = new GlideRecord('sys_user');
checkManagerGr.addQuery('manager', previous.manager);
checkManagerGr.addQuery('u_group_management_member', true);
checkManagerGr.query();

var managerNames = [];

while (checkManagerGr.next()) {
var nameManager = checkManagerGr.getValue('user_name');
managerNames.push(nameManager);
}

[Ankur Bawiskar]

@Tomas Linde 

where have you written this code?

Is this inside a business rule?

What would you want to do with that list?