sort the results in aggregate API by count

amaradiswamy
Kilo Sage

‎02-21-2017 03:24 AM

Hi All,

I have one aggregate API which shows the count of incidents created groupby CI. My requirement is to sort result we got from the rest message based on the count. i.e, CI with maximum count should come first.

Is there anyway to do this?

Thanks and regards

Swamy

0 Helpfuls
  • 1,743 Views
5 REPLIES 5

dvp
Mega Sage
Mega Sage

‎02-21-2017 03:36 AM

Yes you can use



gr.orderByAggregate('count');


0 Helpfuls

dvp
Mega Sage
Mega Sage
In response to amaradiswamy

‎02-21-2017 05:57 PM

as far as I know order by aggregate is not available of an encoded query..


the other way you can do sort after data is received


0 Helpfuls

Arnoud Kooi
ServiceNow Employee
ServiceNow Employee
In response to amaradiswamy

‎02-21-2017 07:49 PM

Set the value of   sysparm to COUNT^DESC or encoded: COUNT%5EDESC



Check the documentation for details:


Aggregate API - GET /now/stats/{tableName}


0 Helpfuls