user criteria for manager

[Abishek1998]

Hi all,

I am having doubts regarding one requirement. The requirement is in user criteria the manager should have atleast one employee reported to him and one of the user should have the employee type as EMPL. I have completed the requirement but need ur help to check.

var answer = false;

var currentUser = gs.getUser().getRecord();

answer = (

    currentUser.getValue("active") == "1" &&

    currentUser.getValue("u_employee_type").toLowerCase() == "empl" &&

    _isManager(gs.getUserID())

);

function _isManager(userID) {

    var userGA = new GlideRecord("sys_user");

    userGA.addQuery("manager", userID);

    userGA.addActiveQuery();

    userGA.query();

    var directreportee = false;

    while (userGA.next()) {

        directreportee = true;

        if (userGA.getValue("u_employee_type").toLowerCase() == 'empl') { //userGA.getAggregate("COUNT")

            return true;

        }

    }

    return directreportee;

}

[Ankur Bawiskar]

@Abishek1998 

use this and give proper query

var userGA = new GlideRecord("sys_user");
userGA.addQuery("manager", user_id);
// employee type contains empl give proper query here
userGA.addEncodedQuery('u_employee_typeLIKEempl'); 
userGA.addActiveQuery();
userGA.setLimit(1);
userGA.query();
answer = userGA.hasNext();

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Abishek1998]

Thanks,

But it should also check atleast one employee is reported to the manager,

if the user should have employment type as EMPL.

[Ankur Bawiskar]

@Abishek1998 

script I shared above should work fine

It checks if logged in user is manager of at least 1 user which is of that type

Did you try? what's your outcome? what debugging did you do?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@Abishek1998 

your code is also fine.

Did you check what debugging you performed?