Report script less than 5 tasks closed per user (tasktable)

[rosti]

Hey all

I have a customer who only wants to see a list report that gives only users who have closed less than 5 tasks over 30 days (All Tasks)

I see that there are limitations in the creation of a report and would like to hear from you experts how a script could be used for this and which I call via the report.

Thank you for your support.

[Sonu Parab · Accepted solution]

Hi @rosti ,
The issue is in the encoded query line in script include.
The encodedQuery should be link this:

and I have observed that in your script line there is javascript&colon.

gr.addEncodedQuery("closed_atONLast 30 days@javascript:gs.beginningOfLast30Days()@javascript:gs.endOfLast30Days()");
gr.addAggregate('COUNT', 'closed_by');

could you please make these changes.
this will work.

[Sonu Parab]

Just wanted to confirm here Fullfiller   is a field on user table.

[rosti]

No it´s a part of sys_user_has license where we have ha role called IT Service Management Professional - Fulfiller User V2

[Sonu Parab · Accepted solution]

Hi @rosti ,
I have updated the script include If condition to check the fulfiller role. rest of the script is as it is.

  if (gr.getAggregate('COUNT', 'closed_by') < 5) { // here we are checking aggregate count

                var closesby = gr.closed_by.toString(); //Get closed by user i.e.user sys_id
                var role = "itil"; // Here  you can pass role called IT Service Management Professional. 
                var checkrole = gs.getUser().getUserByID(closesby).hasRole(role);// ckecking closed by user having fulfiller role
                if (checkrole) { // if true then and then only push sys_if into array.
                    usersys.push('' + closesby);
                }
            }

[rosti]

Thanx's for you assistance  Sonu Parab really appreciated .