question GlideAggregate Error: Skip invalid GroupBy condition: ORDERBYundefined in Developer forum

GlideAggregate Error: Skip invalid GroupBy condition: ORDERBYundefined

NehaSNOW — Wed, 12 Mar 2025 07:19:56 GMT

Hi Members,

I am running the below GlideAggregate script in the Script Backgroung to get the Count of the Incidents per the State wise.

Issue: - Getting the error: -

Skip invalid GroupBy condition: ORDERBYundefined
*** Script: NEHA COUNT of Incidents 187

Please suggest.

Script: -

var gaCount = new GlideAggregate('incident');

gaCount.addAggregate('COUNT',gaCount.number);

gaCount.groupBy(gaCount.state);

gaCount.query();

while(gaCount.next()){

gs.info("NEHA COUNT of Incidents "+gaCount.getAggregate('COUNT',gaCount.number));

}

Thanks,

Neha Pateria

Re: GlideAggregate Error: Skip invalid GroupBy condition: ORDERBYundefined

Chaitanya ILCR — Wed, 12 Mar 2025 07:37:56 GMT

Hi @NehaSNOW ,

try this

var gaCount = new GlideAggregate('incident'); gaCount.addAggregate('COUNT'); gaCount.groupBy('state'); gaCount.query(); while (gaCount.next()) { gs.info("NEHA COUNT of Incidents " + gaCount.state.getDisplayValue() + ' ' + gaCount.getAggregate('COUNT')); }

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

Re: GlideAggregate Error: Skip invalid GroupBy condition: ORDERBYundefined

Ankur Bawiskar — Wed, 12 Mar 2025 07:44:39 GMT

@NehaSNOW

your syntax and script for GlideAggregate is wrong.

Use script shared by @Chaitanya ILCR

More details here

Understanding GlideAggregate

If my response helped please mark it correct and close the thread so that it benefits future readers.

Re: GlideAggregate Error: Skip invalid GroupBy condition: ORDERBYundefined

Ravi Gaurav — Wed, 12 Mar 2025 08:00:36 GMT

Hi @NehaSNOW

Can you please try the below please :-

var x= new GlideAggregate('incident');
x.addAggregate('COUNT');
x.groupBy('state');
x.query();

while (x.next()) {
gs.info("NEHA COUNT of Incidents in State " + x.getValue('state') + " : " + x.getAggregate('COUNT'));
}
Output :-
*** Script: NEHA COUNT of Incidents in State 1 : 45
*** Script: NEHA COUNT of Incidents in State 2 : 32

Re: GlideAggregate Error: Skip invalid GroupBy condition: ORDERBYundefined

Vasanthi_L — Thu, 13 Mar 2025 07:45:10 GMT

Hi,

var ga = new GlideAggregate('incident');

ga.addAggregate('COUNT','state');

ga.query();

while (ga.next()){

gs.info(ga.state.getDisplayValue() + " " +ga.getAggregate('COUNT','state'));

}

Regards