How to sort a list by grouping count in Report?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-23-2021 08:32 PM
In a Report, I would like to sort the list of kb_use table by KB article grouping count in descending order.
Please advise me on how to meet this requirement.
If it's not possible, please kindly let me know some alternatives.
Best Regards,
Aki
- 7,251 Views

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-23-2021 08:38 PM
You can use the following parameters to sort:
&sysparm_group_sort=COUNT
&sysparm_group_sort=COUNTDESC
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-23-2021 08:54 PM
You cannot sort it in report but you can in the list view.
add following parameter in url of list view &sysparm_group_sort=COUNTDESC
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-08-2021 05:09 PM
Hi Pranesh, where in the URL do you insert? Thanks!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-13-2023 03:41 AM
This is how my query looks like and it worked