jquery data tables get data from selected rows

Question

I have a jquery datatable, and have checkboxes which set the row selected class to the rows which are selected. However when I try to get the first column data from these selected rows, it gives me objects.

I am unable to get to the problem inspire of going through a number of posts on the subjects on the data tables and stack overflow forums.

The codes are provided below.

Regards, Arjun

HTML:

<table id="mytable" class="table table-striped table-bordered" cellspacing="0" width="100%">

    <thead>
            <tr>
                <th><input type="checkbox" name= "check_all" id="check_all"/></th>
                <th>Request ID</th>
                <th>Request Date</th>
                <th>Leave Type</th>
                <th>Start Date</th>
                <th>End Date</th>
                <th>Status</th>
            </tr>
        </thead>
    </table>

Javscript

$("#check_all").click(function () {
    $(".checkBoxClass").prop('checked', $(this).prop('checked'));
});

$(".checkBoxClass").change(function(){
    if (!$(this).prop("checked")){
        $("check_all").prop("checked",false);
        $(this).closest('tr').removeClass('row_selected');
    }
        $(this).closest('tr').addClass('row_selected');
});

function sendval(){
    var apprReq = [];
    var rejReq = [];

    var otable = $('#mytable').DataTable();
    var aTrs = otable.rows();

    for ( var i=0 ; i<aTrs.length ; i++ )                                       
    {
        if ( $(aTrs[i]).hasClass('row_selected') )
        {
            apprReq.push( aTrs.rows().data[i] );
        }
            rejReq.push( aTrs[i] );
    }
    console.log(apprReq);
    console.log(rejReq);

}

Vanojx1 · Accepted Answer · 2015-11-03 12:03:43Z

2

from datables doc you can do:

var table = $('#mytable').DataTable();
var rows_selected = table.rows('.row_selected').data();
$.each(rows_selected,function(i,v){
    apprReq.push(v);
});

edited Nov 3, 2015 at 12:03

answered Nov 3, 2015 at 9:08

Vanojx1

5,5842 gold badges25 silver badges37 bronze badges

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

1 Comment

Arjun Bhandari Over a year ago

the data is not a function. however it works in getting all the data

Dion · Accepted Answer · 2017-08-15 16:33:39Z

0

Getting the data without using the class 'row_selected'

https://stackoverflow.com/a/45694629/3514293

edited Aug 15, 2017 at 16:33

answered Aug 15, 2017 at 14:07

Dion

531 gold badge1 silver badge7 bronze badges

Collectives™ on Stack Overflow

jquery data tables get data from selected rows

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related