Laravel-datatables: sorting doesn't work with DT_RowIndex , it searches for a column named DT_RowIndex when sorting button is pressed.

[akilpatel]

Sorting of the column with DT_RowIndex values. screenshot of error is attached.

columns: [
              { data: 'id', name: 'id'},
              { data: 'DT_RowIndex', name: 'DT_RowIndex', "orderable":true, "ordeing":true, "searchable":true, "className" : "my_class"},
             {
                        "className":'details-control',
                        "orderable":false,
                        "ordeing":false,
                        "searchable":false,
                        "data":null,
                        "defaultContent":''
                    },

System details

• PHP Version 7.2
• Laravel Version 5.7

[yajra]

DT_RowIndex is a computed column, thus searching and sorting are expected not to work when using it. Unless the value was fetched from the database too.