When I did a group by on list view, it is showing 100 records per page. How to limit that to 20?

[Ajay37]

Hi,

I have created a database view by joining RITM and Approval tables. When I ran it, it shows only 20 records per page on list view. I then created a report on the database view and grouped with RITM number, now it shows 100 records per page. I removed group by and checked, and it shows 20 records per page then. How to limit to 20 records per page when I did group by, because I use this report in dashboard and having 100 records per page may cause performance issues right?

When Group by is none, it shows only 20 records.

When grouped with number, it is showing 100 records.

Default is 20 rows per page itself:

Thanks

[Community Alums]

Hi Ajay,

Try this way :

 Goto --> System Properties --> Ui Properties and Search for Items per page

and Find Items per page 

Here mention the number of records you want to see in the list separated by a comma.

And save.

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[Ajay37]

Hi @Sandeep Dutta ,

Thanks. I want to limit the row count to 20 itself, which is already defined as user preference as shown in last picture. But still it is showing 100 records per page. Hope you get my point!

[eyal abu hamad]

I have same problem, did you find the solution ?

[Madhu76]

• This is working as expected as per the platform design. It can be an enhancement request.
• As per the below Servicenow docs, it is mentioned that :
  "Note: The maximum number of records shown per group is the number of records per page in list view."
  https://docs.servicenow.com/bundle/washingtondc-platform-user-interface/page/use/using-lists/concept...
  
  For example:
  Setting "Number of rows" to 10 on a grouped list menu, will display only maximum of 10 records per each group, although the group count is higher than 10.
  
  Hope this helps!
  Best regards,