Skip to content
Icon

WARNING You're browsing the documentation for an old version of LARAVEL-DATATABLES. Consider upgrading your project to laravel-datatables 11.0.

Order by NULLS LAST

This api will set Datatables to perform ordering with NULLS LAST option.

use Datatables;
 
Route::get('user-data', function() {
$model = App\User::query();
 
return Datatables::eloquent($model)
->orderByNullsLast()
->make(true);
});

You must update nulls_last_sql config and use a pattern that matches your DB Driver.