Max grouped by rows in SOW

[JB SuW]

Heya,

when I use the "Group by" function in the SOW, the groups seem to be limited to 20, no matter how many rows per page I set.

Is there any way to adjust the limit of shown grouped entries?

Thanks in advance!

[Dr Atul G- LNG]

Hi @JB SuW 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0694134#:~:text=By%20default%....

Might be some helpful.

[JB SuW]

Hey @Dr Atul G- LNG,

Unfortunately, this does not solve my issue.
As shown in the screenshot, I set the value to 100, but I still only get 20 groups with a total of 20 rows.

I would understand if the maximum number of displayed groups per page was defined by the entries, but to me it looks like they are always limited to 20.

[Dr Atul G- LNG]

Hi @JB SuW 

In the native view, it shows more, but in the SOW view it only shows 20. This could be due to the design or might be a limitation of the SOW view.

[Ankur Bawiskar · Accepted solution]

@JB SuW 

it's a platform design of showing group count limit as 20 and is done to avoid performance issues.

You cannot change this.

This limit exists regardless of the “rows per page” setting because grouping is processed before pagination.

If my response helped please mark it correct and close the thread so that it benefits future readers.