How to Search in Related Model (users) from a Livewire Table

[2020-JAUG]

Hi all,

I am using the Laravel Livewire Tables package, and I have a subscribers table that is related to a customers table, which in turn is related to a users table.

I want to lookup the subscriber's first and last name (which are stored in users) directly from my Livewire DataTable without using aliases, because with aliases my table either doesn't display or the lookup doesn't work.

This is what finally worked for me (at least the table is rendered and displayed correctly):

public function builder(): Builder
{
    return Suscriber::query()
        ->leftJoin('customers', 'suscribers.customer_id', '=', 'customers.id')
        ->leftJoin('users', 'customers.user_id', '=', 'users.id')
        ->select('suscribers.*', 'users.name', 'users.last_name', 'users.dni')
        ->orderBy('suscribers.id', 'desc');
}

public function columns(): array
{
    return [
             Column::make(__("Name"), "customer.user.name")
                ->sortable()
                ->searchable(function (Builder $query, string $term) {
                    $like = '%' . $term . '%';
                    $query->whereHas('customer.user', function ($q) use ($like) {
                        $q->where(function($query) use ($like) {
                            $query->where('name', 'like', $like)
                                ->orWhere('last_name', 'like', $like)
                                ->orWhereRaw("CONCAT(name, ' ', last_name) like ?", [$like])
                                ->orWhereRaw("CONCAT(last_name, ' ', name) like ?", [$like]);
                        });
                    });
                }),
            Column::make(__("Surnames"), "customer.user.last_name")
                ->sortable()
                ->format(fn($value, $row, $column) => '<a href="' . route('suscribers.show', $row->id) . '" class="text-decoration-none text- 
               dark">' . $value . '</a>')
                ->html()
    ];
}

This “works” only to view the data, but when I enter a first name + last name, it does not bring me the result. And the data exists in the database :S

Any tips, advice, or best practices are very welcome! Thank you in advance!

[2020-JAUG]

I solved it this way

   ->searchable(
                    function ($query, $searchTerm) {
                        $query->whereHas('customer.user', function ($query) use ($searchTerm) {
                            $query->where('name', 'like', '%' . $searchTerm . '%');
                        })->orWhereHas('customer.user', function ($query) use ($searchTerm) {
                            $query->where('last_name', 'like', '%' . $searchTerm . '%');
                        })->orWhereHas('customer.user', function ($query) use ($searchTerm) {
                            $query->whereRaw("CONCAT(name, ' ', last_name) LIKE ?", ["%{$searchTerm}%"]);
                        })->orWhereHas('customer.user', function ($query) use ($searchTerm) {
                            $query->whereRaw("CONCAT(last_name, ' ', name) LIKE ?", ["%{$searchTerm}%"]);
                        });
                    }
                )