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 12.0.

Manual Search

You can optionally write your own manual filtering functions and thus disabling global search of the package. To achieve this, you can use the filter api.

use DataTables;
 
Route::get('user-data', function() {
    $model = App\User::query();
 
    return DataTables::eloquent($model)
                ->filter(function ($query) {
                    if (request()->has('name')) {
                        $query->where('name', 'like', "%" . request('name') . "%");
                    }
 
                    if (request()->has('email')) {
                        $query->where('email', 'like', "%" . request('email') . "%");
                    }
                })
                ->toJson();
});

To enable global search with filter api, just set the 2nd argument to true.

use DataTables;
 
Route::get('user-data', function() {
    $model = App\User::query();
 
    return DataTables::eloquent($model)
                ->filter(function ($query) {
                    if (request()->has('name')) {
                        $query->where('name', 'like', "%" . request('name') . "%");
                    }
 
                    if (request()->has('email')) {
                        $query->where('email', 'like', "%" . request('email') . "%");
                    }
                }, true)
                ->toJson();
});
Edit this page on GitHub