Groups not counted towards line count

[petpedro]

Hello,

I’ve reached a bug/limitation and I’m not sure if there’s a workaround for it.

I developed a code that allows creating grouped data by levels, with the ability to collapse or expand them. The code works well, but I’ve run into a problem: my table has a lot of rows, which is why I divided them into groups. However, if I limit each page to 20 rows for example, it doesn’t count the groups as rows — only the rows inside the last-level group. This causes the pagination to happen every 20 rows of the lowest level.

As a result, for large groups, instead of having one single group with all the related rows, it creates a new group on each page, limited to the maximum number of rows per page. If I remove the row limit, it works fine, but then I end up with an infinite scroll.

Is there anything I can do to fix or work around this situation?

[AllanJard]

Your only option in DataTables would be to disable pagination. The paging does not take account of row grouping at this time. It might in future, but that isn't something that I'm planning to work on in the immediate future I'm afraid.