CODEWITHSUNDEEP
laraveldatatablesyajra-datatable
Swim89
Swim89

Reputation: 310

Yajra DataTables orderColumn on eloquent doesn't work

I'm using Yajra DataTables on my Laravel 7 project. I have a problem on orderColumn API. Here my code:

return Datatables::eloquent(Company::query())
        ->orderColumn('name', '`column` $1')
        ->make();

But the generated query is:

select * from `companies` where `companies`.`deleted_at` is null order by `id` asc limit 10 offset 0

Can anyone help me?

Upvotes: 0

Views: 509

Answers (1)

Ricky Orlando Napitupulu
Ricky Orlando Napitupulu

Reputation: 516

i know its too late but i just face this problem too and fix this with this code 

return Datatables::eloquent(Company::query())
    ->order(funtion($q){
        $q->orderBy('colName', 'desc');
    })
    ->toJson();

hope this can helpfull

Upvotes: 1

Related Questions