Some PDIs are currently unavailable, and PDI actions are paused. View the latest updates here. Read More

I want to sort the grouped list in descending order by number.

bonsai
Mega Sage

I would like to be able to freely configure the sort order for a grouped list.
Ideally, I’d at least like to sort by number in descending order...
Does anyone know how to do this?

When there is a large number of records, I want the most recent record to appear at the top.

bonsai_0-1783468149962.png

 

2 ACCEPTED SOLUTIONS

Sandeep Rajput
Tera Patron

@bonsai It looks like the group sort only supports only three options. Tried changing the sort using the URL but it didn't work.

View solution in original post

Ankur Bawiskar
Tera Patron

@bonsai 

not feasible

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

7 REPLIES 7

Sandeep Rajput
Tera Patron

@bonsai It looks like the group sort only supports only three options. Tried changing the sort using the URL but it didn't work.

Tanushree Maiti
Tera Patron

Hi @bonsai 

 

 

Refer: KB2902605 Sorting a Grouped List View by Count 

 

Resolution

Did you know that you can sort a List View by the count of grouped items?
You can very easily with the use of the following URL Parameters:
 
"&sysparm_group_sort=COUNT" —> This will sort the List View so the lowest number of grouped items is at the top
"&sysparm_group_sort=COUNTDESC" —> This will sort the List View so the highest number of grouped items is at the top
 
Simply append either to the end of the URL after you do a Group By like this:
 
 
 
Please Accept the solution if it assisted you with your question & Mark this response as Helpful.
Regards
Tanushree Maiti
ServiceNow Technical Architect
LinkedIn: https://www.linkedin.com/in/tanushreemaiti