Unknown column 'DT_Row_Index' in 'order clause'

[rebornishard]

Summary of problem or feature request

i add
->addIndexColumn()

in Controller,

in view I add

{ data: 'DT_Row_Index', name: 'DT_Row_Index' }

This error always appear :
Unknown column 'DT_Row_Index' in 'order clause'

[yajra]

It's added column and not part of the DB that's why it's not sortable. To fix, do:

{ data: 'DT_Row_Index', name: 'DT_Row_Index' , orderable: false, searchable: false}

[rebornishard]

@yajra Thanks a lot yajra, is that impossible to sort that coloumn ?

[yajra]

Yes, I think it's impossible because index column is not part of the database / query. My usual guide is if it's doable on SQL level, the package should be able to handle it. Otherwise, it's not possible.

[rebornishard]

@yajra : ok I get it, btw thanks again for this great package,

how about adding notes for this one :
{ data: 'DT_Row_Index', name: 'DT_Row_Index' , orderable: false, searchable: false}

in : https://yajrabox.com/docs/laravel-datatables/master/index-column

[yajra]

Oh thanks, will add that when I got the chance. You can also PR if you can at https://github.com/yajra/laravel-datatables-docs/blob/master/index-column.md. Thanks!

[MubinSayed]

name: 'DT_Row_Index' , orderable: false, searchable: fals

DT_RowIndex

{ data: 'DT_RowIndex', name: 'DT_RowIndex' , orderable: false, searchable: false}

[riansefriadi]

It's added column and not part of the DB that's why it's not sortable. To fix, do:

{ data: 'DT_Row_Index', name: 'DT_Row_Index' , orderable: false, searchable: false}

it's work for me thanks