SOLVED - Row grouping - Maintain the group values fixed while sorting

leopucci

Hi there!

I am using this example (https://datatables.net/examples/advanced_init/row_grouping.html)

It works fine if you don´t need to sort columns.
But when I click on any colum filtering, it brokes the grouping and filter all info.

Before: http://prntscr.com/7spuk9

After: http://prntscr.com/7spv85

So it does not keep grouping TOGETHER if creates several sub-groups.

Is there a way to do it?

My thinking on api.column.data.each was to create a row to make the filtering work, like adding something like A, A1,A2,A3,A4,B,B1,B2.

My intention is to filter from the bigger group, to the smaller.

Anyone achieved something like that?

Thanks,

Pucci

leopucci

Solved using rowgrouping plugin. But i had to downgrade

My problem on downgrading was with bootstrap theme.

So to achieve, i had to downgrade to the versions founded here: http://fgeorges.org/test/data-tables-bootstrap-3/ (Thanks Georges)

Also downgraded functions to legacy 1.9.4 datatable.

leopucci

Seems that i found another solution with the new version:

http://stackoverflow.com/questions/22745508/jquery-datatables-grouped-row-with-biggest-number-in-another-column-to-appear-fi

here: http://jsfiddle.net/PJk44/