Skip to content
YajraBox

Laravel DataTables
Icon

WARNING You're browsing the documentation for an upcoming version of Laravel DataTables. The documentation and features of this release are subject to change.

Order By Nulls Last

This API will set DataTables to perform ordering with NULLS LAST option.

Basic Usage

use Yajra\DataTables\Facades\DataTables;
use App\Models\User;
 
Route::get('user-data', function() {
    $model = User::query();
 
    return DataTables::eloquent($model)
        ->orderByNullsLast()
        ->toJson();
});

Configuration

[!IMPORTANT] You must update the nulls_last_sql config to use a pattern that matches your database driver.

MySQL Configuration

MySQL treats NULL values as smaller than non-NULL values, so NULLS LAST is the default behavior.

// config/datatables.php
'nulls_last_sql' => '%s %s',

PostgreSQL Configuration

// config/datatables.php
'nulls_last_sql' => '%s %s NULLS LAST',

Oracle Configuration

// config/datatables.php
'nulls_last_sql' => '%s %s NULLS LAST',

See Also

Edit this page on GitHub