getValue not working for GlideAggregate

[caffry]

unable to get the Value of short description using GlideAggregate

var agg = new GlideAggregate('incident');
agg.addAggregate('COUNT', 'category');
agg.orderBy('assigned_to');
agg.orderBy('state');
agg.addQuery('sys_created_on', '>=', 'javascript:gs.beginningOfLast12Months()');
agg.query();
while (agg.next()) {
 
    gs.print(agg.getValue("short_description"));
    
}

Note: i doesnt want to use GlideRecord .

Is it possible to get the value of a field using GlideAggregate

[Ian Mildon]

I've never tried to pull field values like that with GlideAggregate but it may be possible.

You could try with something like: 

gs.print(agg.short_description);

Or define it as a var, then call the var:

var getDesc = agg.short_description;
gs.print(getDesc);

[caffry]

Hi Ian,

Even i have tried the approach which u said still no luck..

its returning empty value

[Ian Mildon]

Wasn't sure if it would work either, but thought it worth a shot

[Ankur Bawiskar]

Hi,

you can only get the value of the field which is used for aggregation i.e. category in your example

Regards
Ankur