Relation column search

I have the following column:

        Tables\Columns\TextColumn::make('person.full_name')
                    ->searchable(['person.first_name', 'person.last_name'])
                    ->label(__('labels.name'))
                    ->sortable(),

        Tables\Columns\TextColumn::make('person.full_name')
                    ->searchable(['person.first_name', 'person.last_name'])
                    ->label(__('labels.name'))
                    ->sortable(),

I know this is propably a bit of a stretch, but i would like this to work, instead i'm getting this error: https://flareapp.io/share/dPbWEeX7

Flare

SQLSTATE[42P01]: Undefined table: 7 ERROR: missing FROM-clause entry for table "person" LINE 1: ... "children"."person_id" = "people"."id" and lower(person.fir... ^ (Connection: pgsql, SQL: select count(*) as aggregate from "children" where (exists (select * from "people" where "child...

2 Replies

DanielvdSpoelOP•13mo ago

bumb

Dennis Koch•13mo ago

I don’t think you can pass dot separated values but you can try with a closure

Gaming

Programming

Relation column search