Count by location help

[coolgirl]

Hi,

      I am working on map pages. I am trying to replicate the code in 'incident count by location' by giving a different table name but it does not seem to work. May i know where am i going wrong.

This is the code

var uri = gs.getProperty("glide.servlet.uri");  

var count = new GlideAggregate('u_leads');         //u_leads is the table which has the field location

count.addAggregate('COUNT', 'location');

count.query();

while (count.next()) {  

      var loc = count.location;

      var locCount = count.getAggregate('COUNT', 'location');  

      if (locCount > 0) {  

              var item = map.addItem(count);  

              item.latitude = loc.latitude;  

              item.longitude = loc.longitude;  

              item.marker_label = locCount;    

              var link = 'href=' + uri + 'u_leads_list.do?sysparm_query=location%3D' + loc;  

              item.html = '<a ' + link + '>' + loc.getDisplayValue() + ' (' + locCount + ') </a>';

              item.icon = "/star.png";  

              item.icon_width = 20;  

              item.icon_height = 20;  

      }  

}  

Thanks,

Sam

[harry_adjevi · Accepted solution]

Hi Sam,

Not that used to the Aggregate method but here's what I ended up with:

I used a variable u_status that is true or false, so you can replace the true/false with the value of your Status variable(completed, open, closed....)

1. var uri = gs.getProperty("glide.servlet.uri");
2. var count = new GlideAggregate('u_leads');
3. count.addAggregate('COUNT', 'u_location');
4. count.query();
7. while (count.next()) {
8.   var loc = count.u_location;
9.   var locCount = count.getAggregate('COUNT', 'u_location');
11.   var locOpen = 0;
12.   var locClose = 0;
14.   //COUNT THE STATUS = TRUE RECORDS
15.   var counto = new GlideAggregate('u_leads');
16.   counto.addQuery('u_location', loc);
17.   counto.addQuery('u_status','true');
18.   counto.addAggregate('COUNT');
19.   counto.query();
20.   if (counto.next()){
21.   locOpen = counto.getAggregate('COUNT');
22.   }
24.   //COUNT THE STATUS = FALSE RECORDS
25.   var countc = new GlideAggregate('u_leads');
26.   countc.addQuery('u_location', loc);
27.   countc.addQuery('u_status','false');
28.   countc.addAggregate('COUNT');
29.   countc.query();
30.   if (countc.next()){
31.   locClose = countc.getAggregate('COUNT');
32.   }
34.   if (locCount > 0) {
35.   var item = map.addItem(count);
36.   item.latitude = loc.latitude;
37.   item.longitude = loc.longitude;
38.   item.marker_label = (locCount);
39.   item.label_offset_left = -11000;
40.   item.label_offset_top = -2210;
42.   var link = 'href=' + uri + 'u_leads_list.do?sysparm_query=u_location%3D' + loc;
43.   item.html='<a ' + link + '>' + loc.getDisplayValue() + ' (' + locCount + ') - Open = ' + locOpen + ' - Close = ' + locClose + ' </a>';
45.   item.icon = "images/red_marker.png";
46.   item.icon_width = 50;
47.   item.icon_height = 50;
48.   }
49. }

Thank you for marking the question as resolved

Harry

[coolgirl]

Thank you Harry for the help.