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.
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);
}
}
Hello @rosti ,
To achieve your requirement follow below step.
Step 1 - Create one script include. The script will be Client Callable And All Application Scope accessible.
the script as follows:
var fetchusers = Class.create();
fetchusers.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getUsers: function() {
var usersys = [];
var gr = new GlideAggregate("task");
gr.addEncodedQuery("closed_atONLast 30 days@javascript:gs.beginningOfLast30Days()@javascript:gs.endOfLast30Days()");
gr.addAggregate('COUNT', 'closed_by');
gr.query();
while (gr.next()) {
if (gr.getAggregate('COUNT', 'closed_by') < 5) {
// gs.info(gr.number);
var closesby = gr.closed_by.toString();
usersys.push('' + closesby);
}
}
// gs.info(usersys);
return usersys;
},
type: 'fetchusers'
});
Step 2 -
Create Report on the User table.
and Add filter as follows;
Sys ID is one of javascript: new fetchusers().getUsers();
Here fetchusers() is a script include name. and getUsers() is a function in a script include.
If my response successfully addresses your query, I kindly request you to consider marking it as the accepted solution. Doing so can be beneficial for others who might have a similar concern.
Thank you!
