Skip to content

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()
->toJson();
});

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