Export to GitHub

jquery-datatables-row-grouping - issue #47

There is no way to disable initial sorting when using jquery-datatables-row-grouping


Posted on Dec 2, 2012 by Helpful Elephant

What steps will reproduce the problem? 1. Define table with grouping using jquery-datatables-row-grouping plugin 2. set "aaSorting": [] The table appear sorted

  1. set "bSort": false The table appears not sorted, but is not sortable at all, which was not the original intention.

What is the expected output? What do you see instead? "aaSorting": [] suppose to disable initial sorting, while the table will still be sortable.

What version of the product are you using? On what operating system? server is Centos 6, jquery is 1.7.1, datatabales is 1.9.1, jquery-datatables-row-groupingi is 1.2.7 running in Chrome on Windows

Please provide any additional information below.

Comment #1

Posted on Jul 11, 2013 by Happy Rabbit

I'm also looking for this issue to be fixed. I have my server handle the sort and datatables leaves that alone for me, but when I use the grouping plugin, it sorts it by the grouping, which I don't want.

Comment #2

Posted on Oct 2, 2013 by Happy Lion

any luck on this? this completely defeats the purpose of my table. group and sort are not the same thing why are they being treated as such?

Comment #3

Posted on Oct 2, 2013 by Happy Lion

nm I solved by commenting out lines 626-632, seems to work

var aaSortingFixed = new Array(); aaSortingFixed.push([properties.iGroupingOrderByColumnIndex, properties.sGroupingColumnSortDirection]); if (properties.iGroupingColumnIndex2 != -1) { aaSortingFixed.push([properties.iGroupingOrderByColumnIndex2, properties.sGroupingColumnSortDirection2]); } // end of if (properties.iGroupingColumnIndex2 != -1)

        oTable.fnSettings().aaSortingFixed = aaSortingFixed;

Comment #4

Posted on May 22, 2015 by Quick Kangaroo

3 will not fix the problem.

This will disable the sorting part and grouping as well. I mean we get rid of sorting but grouping is not proper after applying #3.

Comment #5

Posted on Aug 3, 2015 by Happy Monkey

Under categories I need to show some profiles. Initially from the database I am fetching the data with categories as asc sorting and need to show as it is. However Jquery is making the default sorting with first column. If I remove the sorting feature I can show the grid correct initially but I also need to have Sorting feature in the grid. Can anyone please let me know if you found any custom code for this.

Regards Madhu

Comment #6

Posted on Aug 3, 2015 by Happy Monkey

Note : I am using the category column as the row grouping.

Status: New

Labels:
Type-Defect Priority-Medium