ABC group members is not part of Level 1 and Level 2 cost center users

[raj149]

Hello Experts,

My requirement is 

I want users details in a report who is part of ABC group is not part of  cost center table Level1 approver(reference field) and level 2 approver(reference field).

So I created script include but when i run report it is taking so much of time to get results and instance also not working 

In report the condition is sysID is javascript: TestL1L2Approver();

Is there any mistake in my script 

function TestL1L2Approver(){

mem =[];

var grMembers = new GlideRecord('sys_user_grmember');

    grMembers.addQuery('group' ,'e5302b2d1b4e11506ece2fc5604bcb5c');

    grMembers.query();

    while (grMembers.next()) {

        var userSysID = grMembers.user.toString();

        var Levelone = new GlideRecord('cmn_cost_center');

        Levelone.addQuery('u_level_1_approver', userSysID);

        Levelone.query();

        while (!Levelone.next()) {

            var Leveltwo = new GlideRecord('cmn_cost_center');

            Leveltwo.addQuery('u_level_2_approver', userSysID);

            Leveltwo.query();

            while(!Leveltwo.next()) {

                mem.push(grMembers.user);

            }

        }

    }

return mem;

}

Best Regards,

Raj

[raj149]

Hello @Ankur Bawiskar 

Did you got any solution....?

Best Regards,

Raj