List view shows only 20 records always

Khanna Ji
Tera Guru

Hi Friends,

 

Does anybody know why list view shows only 20 records when we group by any field even when Show is set to 100 records per page?

 

When I remove group by that configuration is honored but doesn't work for group by.

 

KhannaJi_0-1766116156759.png

 

4 REPLIES 4

Hemanth M1
Giga Sage
Giga Sage

Hi @Khanna Ji ,

 

Seems to be the expected behavior when you group by, regardless of your view count preference!

 

you can also refer - https://www.servicenow.com/community/platform-analytics-forum/list-type-reports-using-the-group-by-f... 

 

 

 

Accept and hit Helpful if it helps.

Thank you,
Hemanth
Certified Technical Architect (CTA), ServiceNow MVP 2024, 2025

Ankur Bawiskar
Tera Patron
Tera Patron

@Khanna Ji 

this is platform OOTB behavior

my thoughts

-> ServiceNow paginates and groups reference field records based on the "Items per page" UI property. If set to 20, only the first 20 records per group are displayed, regardless of the total matching records.

-> When scripted filters or before-query business rules apply, condition order can affect results—especially if rules aren’t strictly AND-based or conflict with filters. Rearranging filters may show more records, but not all.

check these links for reference

AnkurBawiskar_0-1766121985783.png

 

AnkurBawiskar_1-1766121985785.png

 

 

Grouped lists 

The users see different number of records based on sorting order in the list view. 

💡 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  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Do we have a KBA or documentation stating this is OOTB behaviour? If not then where in the instance you can show me its due to so and so code or script or property?

@Khanna Ji 

check this KB, it says you can alter that but will lead to performance issue

When doing group by the number of records shown per group is the same number of records per page in ... 

also check this

Pagination does not work as expected when "Group By" is applied on any List Column and number of ite... 

💡 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  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader