How can I sort by grouping Count?

[Stephen11]

I am trying to sort by the count of incidents that a change is related to.  How might I go about this?

[Zack S]

Thanks! Works great!

For other people, you just have to append these to the end of your query url.

[Michael QCKM]

Will, as awesome as this is - Thank you by the way - it is NOT part of my standard reporting abilities, and I can't add it and have it saved. (Yes, I can make a report, add that, and share that new URL with people, but it's not saved IN the report.)

I do appreciate the find though and will leverage it as able.

[Abhishek Pande2]

Hi Will

I might sound strange but being a novoice servicenow developer I am not sure how to use this solution and where to apply?

I have goiven a try, please correct me:

https://dev109773.service-now.com/nav_to.do?uri=%2Fincident_list.do%3Fsysparm_query%3DGROUPBYassignment_group&sysparm_group_sort=COUNT

Thanks

Abhishek Pandey

[Zack S]

I have not tested this, but I believe the new URL should be something like: 

https://dev109773.service-now.com/nav_to.do?uri=%2Fincident_list.do%3Fsysparm_query%3DGROUPBYassignment_group%26sysparm_group_sort%3DCOUNT

due to URL encoding.

If that doesn't work, please provide more information about how this is being used (i.e. In a browser's URL box, or in a scripted query).

[Abhishek Pande2]

Thanks!

I tried encoded URL but had no luck but this time it work like charm.