It can also be executed using glideAggregate
var inc = new GlideRecord('incident');
//inc.addActiveQuery();
inc.query();
var cat=["inquiry" , "software" , "hardware" , "network" , "database"];
var c1=0, c2=0, c3=0, c4=0, c5=0 , c6=0;
while(inc.next())
{
if(inc.category == cat[0])
{
c1++;
//gs.addInfoMessage(inc.number+" = "+" , "+c1+" "+cat[0]);
}
else if(inc.category == cat[1])
{
c2++;
//gs.addInfoMessage(inc.number+" = "+" , "+c2+" "+cat[1]);
}
else if(inc.category == cat[2])
{
c3++;
//gs.addInfoMessage(inc.number+" = "+" , "+c3+" "+cat[2]);
}
else if(inc.category == cat[3])
{
c4++;
//gs.addInfoMessage(inc.number+" = "+" , "+c4+" "+cat[3]);
}
else if(inc.category == cat[4])
{
c5++;
//gs.addInfoMessage(inc.number+" = "+" , "+c5+" "+cat[4]);
}
else if(inc.category == "")
{
c6++;
gs.addInfoMessage(inc.number+" = "+" , "+c6+" BLANK CATEGORY");
}
}
gs.addInfoMessage("Category = "+cat[0]+" , total number of record = "+c1);
gs.addInfoMessage("Category = "+cat[1]+" , total number of record = "+c2);
gs.addInfoMessage("Category = "+cat[2]+" , total number of record = "+c3);
gs.addInfoMessage("Category = "+cat[3]+" , total number of record = "+c4);
gs.addInfoMessage("Category = "+cat[4]+" , total number of record = "+c5);
gs.addInfoMessage("Category = BLANK CATEGORY , total number of record = "+c6);
gs.addInfoMessage(inc.getRowCount());
No comments:
Post a Comment