Hi @ganeshnerni
You did not give the full details so assuming you are referring to the Incident report.
Table: Incident
Report Type : Bar
Hi @ganeshnerni ,
You can use below script for your use case.
var inc_count;
var ga_inc = new GlideAggregate("incident");
ga_inc.addAggregate("COUNT","assignment_group");
ga_inc.query();
while(ga_inc.next())
{
var c=1;
inc_count = ga_inc.getAggregate("COUNT","assignment_group");
if(ga_inc.assignment_group)
{
gs.info("Assignment Group: " + ga_inc.assignment_group.getDisplayValue() + " have " + inc_count + " number of incidents." + ga_inc.number);
var gr_inc = new GlideRecord("incident");
gr_inc.addQuery("assignment_group",ga_inc.assignment_group);
gr_inc.query();
while(gr_inc.next())
{
gs.info("S.No: " + c + " " + gr_inc.number);
c=c+1;
}
}
else
{
gs.info("Assignment Group is empty and have " + inc_count + " number of incidents.");
var gr_inc = new GlideRecord("incident");
gr_inc.addQuery("assignment_group",ga_inc.assignment_group);
gr_inc.query();
while(gr_inc.next())
{
gs.info("S.No: " + c + " " + gr_inc.number);
c=c+1;
}
}
}
Refer the snip
Output: Incident list view grouped by assignment group, showing the count of incidents for each group and printing the incident number for each assignment group.
Incident List View Group By Assignment Group
If my response helped, then accept the solution and hit the thumbs up, so that it benefits the future reader and also me for your efforts towards the community.
Regards,
Rohit
