kdion4891/laravel-livewire-tables

How can I use search on secondary table in joining statement?

codepoetryindia opened this issue · 0 comments

public function query()
{
$response = Transaction::latest()->select('transactions.*', 'users.name', 'users.mobile')
->join('users', 'transactions.user_id', 'users.id');
return $response;
}

public function columns()
{
return [
// Column::make('ID')->searchable()->sortable(),
Column::make("Date", 'created_at')->view('livewire.admin.partial.common.date-format')->sortable(),
Column::make('Order No', 'order_id')->searchable()->sortable(),
Column::make('Name', 'name')->searchable('users.name')->sortable(),
Column::make('Amount')->sortable(),
Column::make("Payment", 'payment_status')->view('livewire.admin.partial.common.payment-status'),
Column::make("Service", 'order_status')->view('livewire.admin.partial.common.service-status'),
Column::make()->view('livewire.admin.partial.common.common-action'),
];
}