JQuery DataTables - Prevent sorting on sortable column

Question

I have a JQuery Datatable with a checkbox in one of the column headings:

<table id="vehTbl" class="table table-striped table-bordered">
  <thead>
    <tr>
        ...
        <th>
            <input type="checkbox" id="someId" onchange="TickAllBoxes()" />
            Publish
        </th>
    </tr>
  </thead>
</table>

My datatable is initialised like this:

var table = $("#vehTbl").dataTable(
    {
        ...
        "aoColumns":
        [
            ...
            {
                "mDataProp": "SomeName",
                "fnRender": somefunction,
                "bUseRendered": false
            },
            ...
        ]
    });

So this column is sortable. Now I need to prevent the sort event from being fired when checkbox is clicked (and TickAllBoxes is fired as a result). The sorting should work on the column otherwise.

What could potentially work is to bind a handler to "sort" event of the table and prevent default if caller is "someId" checkbox. I haven't had success in doing so, though.

Any ideas?

yeyene · Accepted Answer · 2013-07-01 04:40:13Z

1

Try to add in this script after your dataTable is initialised, and see?

var table = $("#vehTbl").dataTable(
{
    ...
    "aoColumns":
    [
        ...
        {
            "mDataProp": "SomeName",
            "fnRender": somefunction,
            "bUseRendered": false
        },
        ...
    ]
});
// add in this
$('input[type=checkbox]').click(function(event){event.stopPropagation()});

answered Jul 1, 2013 at 4:40

yeyene

7,4001 gold badge24 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

JQuery DataTables - Prevent sorting on sortable column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related