Simple list "group by" limited to 20

[MikeS_]

Running into what seems to be a limit of 20 groupings displayed within a simple list widget. The data in the picture attached should be showing 30 groupings however its only showing 20. Most other widgets have an option when adding a group by to specify how many groups to display (image attached as well) however this option is absent when working with the list widget. Is there any way to increase this limit? 

[Pavel4]

create and set property glide.db.max.aggregate.size to 100

despite documentation of Available System Properties says its default value is still 100, in Zurich it was lowered down to 20 - see KB2699089

Issue

When Group By is applied on a list view for atable, users can select the number of rows per page using "Show" dropdown (up to maximum of 100). However, once grouping is applied the system ignores the selected value and continues to display only 20 rows per page, even when a higher value is selected.

This behavior is observed in the instances after upgrade to Zurich.

Symptoms

This behavior is platform-infused and was introduced as a part of the platform's default handling for grouped list views. The limitation is intentionally enforced to prevent performance degradation when loading large grouped datasets.

Although this limit can be increased through configuration, increasing the row count beyond the default- especially up to 100 per page. But this may lead to performance issues such as slower list load times. So, increasing the count more than 100 is not recommended.

Release

Zurich Release

Cause

Root Cause
This is an expected behavior change in the Zurich release, where the system applies a default maximum of 20 rows per page for grouped lists unless overridden through the glide.db.max.aggregate.size system property.