![]()
WARNING You're browsing the documentation for an upcoming version of Laravel DataTables. The documentation and features of this release are subject to change.
Filter Column
In some cases, we need to implement a custom search for a specific column.
To achieve this, you can use filterColumn
api.
use Yajra\DataTables\Facades\DataTables;use Illuminate\Support\Facades\DB;use App\User; Route::get('user-data', function() { $model = User::query()->select([ 'id', DB::raw("CONCAT(users.first_name,'-',users.last_name) as fullname"), 'email', 'created_at', 'updated_at', ]); return DataTables::eloquent($model) ->filterColumn('fullname', function($query, $keyword) { $sql = "CONCAT(users.first_name,'-',users.last_name) like ?"; $query->whereRaw($sql, ["%{$keyword}%"]); }) ->toJson();});