Autoincrementing column in datatable

Well, I would add a auto increment or identity column the table.

Hi,

What database or ORM?

Thanks,

Darren

If you are using SQL server, you can define the column as an identity column, read

https://www.w3schools.com/sql/sql_autoincrement.asp

If you are using Oracle, you can define one sequence for such purpose.

Hi,

Datatables have this https://datatables.net/examples/api/counter_columns.html

You need empty

<th></th> <td></td>

Select allOpen in new window

for that column
Then this is the way to use it

$(document).ready(function() {
    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();
} );

Select allOpen in new window

or if you use

"deferRender": true

Select allOpen in new window

$(document).ready(function() {
    var t = $('#example').DataTable( {
        "columnDefs": [ {
            "searchable": false,
            "orderable": false,
            "targets": 0
        } ],
        "order": [[ 1, 'asc' ]]
    } );
                 
    t.on( 'draw.dt', function () {
    var PageInfo = $('#example').DataTable().page.info();
         t.column(0, { page: 'current' }).nodes().each( function (cell, i) {
            cell.innerHTML = i + 1 + PageInfo.start;
        } );
    } );
} );

Select allOpen in new window

Thanks