[Feature Request] Add a search closure

[CrazyBoy49z]

Feature Request

Summary

Add

 Column::add()
                ->title('Full name')
                ->field('full_name')
                ->searchable(function($query, $search) => {
           $search = trim($search);

        return $query->when($search, function (Builder $query, $search) {
            $search = '+'.str_replace(' ', '+', $search);

            return $query->whereFullText(['first_name', 'name', 'last_name'], $search, [
                'mode' => 'boolean',
            ]);
        });
}),

Why is this needed?

Fast use custom search

[LaMance22]

Is it currently possible to search 2 columns (CONCAT) ? I have "first_name" and "last_name" in my database.

[CrazyBoy49z]

So this is a piece of code from my project

App\Models\User;

public function scopeSearch(Builder $query, string $search): Builder
{
    return $query
        ->where(DB::raw("CONCAT(first_name, ' ', name, ' ', last_name)"), 'like', "%{$search}%")
        ->orWhere('phone', 'like', "{$search}%");
}

/*
    |--------------------------------------------------------------------------
    |  Datasource
    |--------------------------------------------------------------------------
    | Provides data to your Table using a Model or Collection
    |
    */
    public function datasource(): ?Builder
    {
        return User::query()
            ->selectRaw( "*, CONCAT(first_name, ' ', name, ' ', last_name) fullname")
            ->when($this->search, function ($query, $search) {
                return $query->search($search);
            });
    }

[LaMance22]

Thank you for your response. Unfortunately, it doesn't work for me. By adding "scopeSearch" to the model, the search for "relationSearch" also stopped working. Can anyone tell you how I can search for 2 columns from the database in the table (e.g. first_name + last_name) ?