How to get top 5 assigned to's with maximum number of incidents?

BijoyDeb
Tera Contributor

Hi,

  I want to get top 5 assigned to persons who have most number of incidents assigned to them.

In the list view of incidents , i can see this if i group by assigned to

But not sure how i can do this by GlideRecord

Please let me know if you have any idea

Thanks!!

1 REPLY 1

z xq
Giga Contributor

@BijoyDeb 

 

Use  GlideAggregate

All the information you need is in the below link.

https://developer.servicenow.com/dev.do#!/reference/api/vancouver/server/no-namespace/c_GlideAggrega...