Getting Selected Row data from jQuery DataTable

Question

I have Try to extract raw data from selected row in jquery datatable. I am using 1.10.7 version.here is my simple code

 var table = $('#Searchtbl').DataTable({
                "columns": [
                            { "data": "poNumber" },
                            { "data": "relnumber" },
                            { "data": "recNumber" },
                            { "data": "vendorName"},

                ],
            });



            $('#Searchtbl tbody').on('dblclick', 'tr', function () {
                console.log(table.row(this).data());
                //$('#searchModel').modal('hide');
            });

but once console get print it saying undefined.Can any one say what i am doing wrong here,

CodeMind · Accepted Answer · 2016-07-01 05:02:37Z

4

Finally i fixed this with this way.Reson is the new version of Datatable library no longer working table.row( this ).data() this way

    var table = $('#Searchtbl').DataTable({
    });


    $('#Searchtbl tbody').on('dblclick', 'tr', function () {
        var tableData = $(this).children("td").map(function () {
            return $(this).text();
        }).get();

        alert("Your data is: " + $.trim(tableData[0]) + " , " + $.trim(tableData[1]) + " , " + $.trim(tableData[2])+ " , " + $.trim(tableData[3])+ " , " + $.trim(tableData[4]));

    });

Cheers..

answered Jul 1, 2016 at 5:02

CodeMind

6461 gold badge8 silver badges20 bronze badges

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

Comments

Muhammad Usman · Accepted Answer · 2016-07-01 04:50:11Z

0

You need this one ??

 $('#example tbody').on( 'click', 'tr', function () {
     console.log( table.row( this ).data() );
 } );

Detail

answered Jul 1, 2016 at 4:50

Muhammad Usman

3551 silver badge12 bronze badges

1 Comment

CodeMind Over a year ago

yes.the table data Dynamically generate by Ajax Request

BeDeveloper · Accepted Answer · 2016-07-01 05:06:16Z

0

Get the data onclick

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

$('#example tbody').on( 'click', 'tr', function () {
    console.log( table.row( this ).data() );
} );

All the Details

answered Jul 1, 2016 at 5:06

BeDeveloper

988 bronze badges

1 Comment

CodeMind Over a year ago

I want on extract row data when double click on it.i have found answer for it.Thanks

Collectives™ on Stack Overflow

Getting Selected Row data from jQuery DataTable

3 Answers 3

Comments

1 Comment

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Related