How to display Many-to-Many relationship?

[rhonautix]

Client Class:

function pocs() : BelongsToMany
    {
        return $this->belongsToMany(PoC::class, 'clients_pocs', 'client_id','poc_id');
    }

PoC Class:

public function clients(): BelongsToMany
    {
        return $this->belongsToMany(Client::class,'clients_pocs','poc_id','client_id');
    }

PocTable Class:

public function builder(): Builder
    {
        return PoC::query()
            ->with('clients');
    }

public function columns(): array
    {
        return [
            Column::make("ID", "id")
                ->sortable()
                ->deselected(),
            Column::make("Name", "name")
                ->sortable()
                ->searchable()
                ->excludeFromColumnSelect(),

            Column::make("Clients", "clients.company_name")  // This line does not work
                ->excludeFromColumnSelect(),                 // I want to display all clients of this POC

            Column::make("Primary Email", "email")
                ->sortable()
                ->searchable()
                ->excludeFromColumnSelect(),
            Column::make("Alt. Email", "alt_email")
                ->sortable()
                ->searchable(),
            Column::make("Mobile", "mobile")
                ->sortable()
                ->searchable()
                ->excludeFromColumnSelect(),
            Column::make("Alt. Mobile", "alt_mobile")
                ->sortable()
                ->searchable(),
        ];
    }

I can't figure out how to display many-to-many relationship.

[rhonautix]

I managed to display it by using label with view method:

Column::make('Companies')
                ->label(
                    fn($row, Column $column) => view('livewire.p-o-c.poc-clients')->withRow($row)
                ),

View:

@foreach($row->clients as $client)
    <div>{{$client->company_name}}</div>
@endforeach

Down side is it's not searchable nor sortable.

[lrljoe]

If you want it sortable/searchable, then you'd need to use a callback in the searchable/sortable function, for example the below is a good jumping off point for you:

Column::make('Companies')
                ->label(
                    fn($row, Column $column) => view('livewire.p-o-c.poc-clients')->withRow($row)
                )
                ->searchable(
                  fn(Builder $query, $searchTerm) => $query->whereHas('clients', function (Builder $query) use ($searchTerm) {
                     $query->where('company_name', 'like', $searchTerm);
                  })
                ),

[rootuser]

Hello,

I was able to adapt this to my table so I basically have a colum from a many-to-many relation.

But the code for implementing 'searchable' does not work for me; I get the error:
App\Livewire\PersonTable::App\Livewire{closure}(): Argument #1 ($query) must be of type Illuminate\Database\Query\Builder, Illuminate\Database\Eloquent\Builder given, called in D:\wamp64\www\verein-laravel\vendor\rappasoft\laravel-livewire-tables\src\Traits\WithSearch.php on line 64

Another thing I am looking for is to restrict the relation. My pivot table has start- end enddates for the relation, and I only want to show the related entries that are inside the valid date.

Could you kindly give me a hint?

Thanks!

Kind regards,
Tom

[lrljoe]

@rootuser - Since this post, there have been many changes/improvements, so best to start a new thread.