Skip to content
YajraBox

Laravel DataTables
Icon

WARNING You're browsing the documentation for an old version of LARAVEL-DATATABLES. Consider upgrading your project to laravel-datatables 10.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()
            ->toJson();
});

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

Edit this page on GitHub