datatables remove rowgrouping

Question

I am using DataTables Row Grouping Add-on. I used it by select box change event.

Code

In PHP :

<select id="Group-Discoveries" name="Group-Discoveries" class="input-medium">
<option value="">None</option>
<option value="6">Domain</option>
<option value="7">Type</option>
<option value="8">Category</option>
<option value="9">Status</option>
</select>

In JS :

$(document).ready(function() {    
var DTable = $('#discovery').dataTable( {
            "sDom": "<'row-fluid'<'span3'<'toolbar'>><'span3'<'selectbar'>><'span6'f>r>t<'row-fluid'<'span6'i><'span6'p>>",
            "bPaginate": false
        });
        $('#Group-Discoveries').live('change', function(){
            var index = $(this).val();
            if(index == ''){

            }
            else{
                DTable.rowGrouping({
                    "iGroupingColumnIndex": index,
                    "bHideGroupingColumn": false,
                    "bHideGroupingOrderByColumn": false,
                    "sGroupingClass":"group_"+index,
                    "bSetGroupingClassOnTR":true,
                    "bExpandableGrouping":true
                });
            }
        });
});

I want to remove rowgrouping when the index is empty.

Thanks.

Have you found out how to do this?

cpoDesign
– cpoDesign

2013-01-07 22:07:37 +00:00
Commented Jan 7, 2013 at 22:07 — cpoDesign
– cpoDesign, Commented Jan 7, 2013 at 22:07
@cpoDesign No, But now I use ajax reloading for that.

Siva.G ツ
– Siva.G ツ

2013-01-08 08:14:52 +00:00
Commented Jan 8, 2013 at 8:14 — Siva.G ツ
– Siva.G ツ, Commented Jan 8, 2013 at 8:14

MiB · Accepted Answer · 2013-02-21 18:50:02Z

3

I found the solution - remove the draw callback that the grouping plugin creates and reset the group sorting:

var oSettings = jQuery('#table').dataTable().fnSettings();

for (f = 0; f < oSettings.aoDrawCallback.length; f++) {
    if (oSettings.aoDrawCallback[f].sName == 'fnRowGrouping') {
        oSettings.aoDrawCallback.splice(f, 1);
        break;
    }
}

oSettings.aaSortingFixed = null;

Hope this helps.

answered Feb 21, 2013 at 18:50

MiB

4801 gold badge5 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

datatables remove rowgrouping

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related