Ad
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?
Ad
Answer
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
Ad
source: stackoverflow.com
Related Questions
- → "failed to open stream" error when executing "migrate:make"
- → October CMS Plugin Routes.php not registering
- → OctoberCMS Migrate Table
- → OctoberCMS Rain User plugin not working or redirecting
- → October CMS Custom Mail Layout
- → October CMS - How to correctly route
- → October CMS - Conditionally Load a Different Page
- → Make a Laravel collection into angular array (octobercms)
- → In OctoberCMS how do you find the hint path?
- → How to register middlewares in OctoberCMS plugin?
- → Validating fileupload(image Dimensions) in Backend Octobercms
- → OctoberCMS Fileupload completely destroys my backend
- → How do I call the value from another backed page form and use it on a component in OctoberCms
Ad