get a field value in the glideAggregate

Must include a groupby clause in order for the getValue (or getDisplayValue() on a reference field) to work

var REQsysid='3eac6cbddb75a81081fb49a23996xxxx'; var agg = new GlideAggregate('sc_req_item'); agg.addQuery('request', REQsysid); agg.addAggregate("COUNT"); agg.groupBy('short_description'); agg.query(); var answer = 0; while( { gs.print( agg.getAggregate("COUNT")); gs.print('SD:'+agg.short_description.getValue()); }


Popular posts from this blog

GlideRecord setValue

URL link in addInfoMessage