How to get 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 

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;

}

 Thanks in advance 

Best Regards

Raj

[Uncle Rob]

No need to script this.  You can get it via conventional reports with Related List Conditions.

Here's a vid I did on it...

[raj149]

Hello@ Robert

Above method will not work.

I want to check ABC group members is part of Level 1 cost center approver or not .

ABC group table name is (sys_user_group)

Level 1 cost center approver field  table name is (cmn_cost_center).

I want to create a report by using script include.

Thanks in advance