GlideAggregate - limiting number of records

MG Casey
Mega Sage

The GlideRecord when making UI Pages makes it very easy to set the number records display by SetLimit().

 

However, when grouping data with GlideAggregate, setLimit does not seem to come into play. I know I can do addHaving, but I'd much prefer not having to have an arbitrary number that I would need to keep updating as records grows.

 

What I'm trying to do: Get a list of the top 3 subcategories of incidents for the previous day

6 REPLIES 6

Wow, that did it! Thank you so much. This opens the door for a lot of homepage gauges we've been looking to create ourselves.



MG


No problem.


This opens the door for a lot of homepage gauges

Uh oh...