Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Datatables 1.10 "Check all" via jquery

I know this might seem primitive, but I've been trying to implement it for a whole day, maybe because I can't fully comprehend how to use the API, I'm using DataTables 1.10.0, I have a table with pagination feature, each row has one checkbox in it, I need to have a "check all button" that would check all the checkboxes in all pages, the problem is that it only checks the checkboxes in the current page, and leaves the other pages unchecked, this is supposed to be easy, but I couldn't figure it out ! the answers I found use "fnGetNodes" which seems to be deprecated and not used by version 1.10

Edit: this is my markup

        <table class="table table-striped table-bordered table-hover" id="numbers_table">
                <thead>
                    <tr>
                        <th><input type="checkbox" id="checkall" title="Select all" onClick="toggle(this)"/></th>
                        <th>Number</th>
                        <th>Company</th>
                        <th>Tags</th>
                    </tr>
                </thead>
                <tbody>
                    <% _.each(array, function (value) { %>
                    <tr>
                        <td><input type='checkbox' name='numbers[]' value='<%=value.id%>'/></td>
                        <td><%= value.number %></td>
                        <td><%= value.company %></td>
                        <td><%= value.tags %></td>
                    </tr>
                    <% }) %>
                </tbody>
            </table>

    <button type="button" class="btn btn-primary" id="checkall2">SELECT ALL</button>

<script>

$(document).ready(function() {

    $('#numbers_table').dataTable({
        //"bPaginate": false,
        "aoColumnDefs": [
      { "bSortable": false, "aTargets": [ 0 ] }
    ] 
        });

    $("#checkall2").click(function() { // a button with checkall2 as its id
        $(':checkbox').prop('checked', true); // all checkboxes, you can narrow with a better selector
    });
});
</script>
like image 874
Bahaa Avatar asked May 13 '14 17:05

Bahaa


1 Answers

This should work for you

var table = $('#numbers_table').DataTable();

    $('#checkall').click(function () {
        $(':checkbox', table.rows().nodes()).prop('checked', this.checked);
    });
like image 196
Jelle Keizer Avatar answered Oct 11 '22 15:10

Jelle Keizer