what is the glide aggregate function?how to use

[preddy1]

what is the glide aggregate function?how to use

[Deepak Ingale1]

Please find below link

The GlideAggregate class is an extension of GlideRecord and allows database aggregation (COUNT, SUM, MIN, MAX, AVG) queries to be done. This can be helpful in creating customized reports or in calculations for calculated fields. 

https://docs.servicenow.com/bundle/jakarta-application-development/page/script/glide-server-apis/con...

Note: Please mark reply as correct if it has answered your question

[preddy1]

where we need to wright these scripts to get the count of a table

[Sindhu B1]

Hi ,

The GlideAggregate class is an extension of GlideRecord and allows database aggregation (COUNT, SUM, MIN, MAX, AVG) queries to be done. This can be helpful in creating customized reports or in calculations for calculated fields.

GlideAggregate examples

count of the number of records

var count = new GlideAggregate('incident');
count.addAggregate('COUNT');
count.query();
var incidents = 0;
if(count.next()) 
   incidents = count.getAggregate('COUNT');



 count of the incidents that were open

var count = new GlideAggregate('incident');
count.addQuery('active','true');
count.addAggregate('COUNT');
count.query();
var incidents = 0;
if(count.next()) 
   incidents = count.getAggregate('COUNT');

open incidents by category

var count = new GlideAggregate('incident');
count.addQuery('active','true');
count.addAggregate('COUNT','category');
count.query();
while(count.next()){
  var category = count.category;
  var categoryCount = count.getAggregate('COUNT','category');
  gs.log("there are currently "+ categoryCount +" incidents with a category of "+ category);}

https://docs.servicenow.com/bundle/jakarta-application-development/page/script/glide-server-apis/con...


Please mark it as correct 
Regards,
Sindhu

[preddy1]

where should i wright these scripts?and the entire script i need to wright that you have given?