How to get row index in Datatables?

Question

I used following javascript to get row index. By using this the ID(table header) always starts with 1 in case next 10 values are selected in every page.i need to show next 10 as 11 to 20. Thank you very much..

  $(document).ready(function() {
             $('#example').dataTable( {
                "processing": true,
        "serverSide": true,
                "ajax": "scripts/server_processing.php",

                "aoColumns": [
                    {
                        "sTitle": "ID"},

                    {
                        "sTitle": "E Mail"},
                    {
                        "sTitle": "FirstName"},
                    {
                        "sTitle": "LastName"},
                    {
                        "sTitle": "Company"},
                    {
                        "sTitle": "Course"},
                    {
                        "sTitle": "Module"},
                    {
                        "sTitle": "Completions"},
                    {
                        "sTitle": "First"},
                    {
                        "sTitle": "Last",
                        "sClass": "center"},
                    {
                        "sTitle": "Lowest"},
                    {
                        "sTitle": "Highest",
                        "sClass": "center"},

//                    {
//                        "sTitle": "#"},
                ],

                 "fnRowCallback": function( nRow, aData, iDisplayIndex, iDisplayIndexFull ) {
                     var index = iDisplayIndex +1;
                     $('td:eq(1)',nRow).html(index);
                     return nRow;
                 }


            });


        });

refer this link stackoverflow.com/questions/6871198/…

madhu
– madhu

2015-07-29 10:42:44 +00:00
Commented Jul 29, 2015 at 10:42 — madhu
– madhu, Commented Jul 29, 2015 at 10:42

Rohit Arora · Accepted Answer · 2015-07-29 10:46:18Z

3

EDIT:

Check out this link Datatables-addrow and code is here:

var t = $('#example').DataTable( {
        "columnDefs": [ {
            "searchable": false,
            "orderable": false,
            "targets": 0
        } ],
        "order": [[ 1, 'asc' ]]
    } );

    t.on( 'order.dt search.dt', function () {
        t.column(0, {search:'applied', order:'applied'}).nodes().each( function (cell, i) {
            cell.innerHTML = i+1;
        } );
    } ).draw();

For getting index in jquery :

$('#example tbody').on( 'click', 'tr', function () {
    alert( 'Row index: '+table.row( this ).index() );
} );

For more information visit Datatables

edited Jul 29, 2015 at 10:46

answered Jul 29, 2015 at 10:39

Rohit Arora

2,2622 gold badges28 silver badges40 bronze badges

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

4 Comments

Dim236 Over a year ago

Thanx but I want to show row index column in table.

Rohit Arora Over a year ago

Match your html code, javascript code properly. any errors in console ?

Dim236 Over a year ago

Rohit Arora Over a year ago

@Dim236 It works for all in the demo. You must recheck it once more.

Collectives™ on Stack Overflow

How to get row index in Datatables?

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related