Version

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

Edit this page on GitHub