datatables表格设置序号自增

datatables表格设置序号自增

背景

从数据库中获取的数据填充到datatables，但是有的时候可能出现序号等问题，但是想要按照行进行递增，而不是按照数据库中的主键进行递增。

解决方案

$(document).ready(function () {let t = $('#declarationList').DataTable({order: [[0, "desc"]], //关键代码language: {"sProcessing": "处理中...","sLengthMenu": "显示 _MENU_ 项结果","sZeroRecords": "没有匹配结果","sInfo": "显示第 _START_ 至 _END_ 项结果，共 _TOTAL_ 项","sInfoEmpty": "显示第 0 至 0 项结果，共 0 项","sInfoFiltered": "(由 _MAX_ 项结果过滤)","sInfoPostFix": "","sSearch": "关键字搜索:","sUrl": "","sEmptyTable": "表中数据为空","sLoadingRecords": "载入中...","sInfoThousands": ",","oPaginate": {"sFirst": "首页","sPrevious": "上页","sNext": "下页","sLast": "末页"},"oAria": {"sSortAscending": ": 以升序排列此列","sSortDescending": ": 以降序排列此列"}}});//关键代码t.on('order.dt search.dt', function () {t.column(0, {search: 'applied', order: 'applied'}).nodes().each(function (cell, i) {cell.innerHTML = i + 1;});}).draw();
});