How to sort a list by grouping count in Report?

Aki17
Kilo Guru

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.

find_real_file.png

 

Best Regards,

Aki

13 REPLIES 13

Mario Quinones1
Mega Guru

You can use the following parameters to sort:

&sysparm_group_sort=COUNT

&sysparm_group_sort=COUNTDESC

Pranesh072
Mega Sage
Mega Sage

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

Hi Pranesh, where in the URL do you insert? Thanks! 

This is how my query looks like and it worked

MarcinKroszel_0-1689244864626.png

MarcinKroszel_1-1689244895622.png