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...

Filament•3y ago•

3 replies

DanielvdSpoel

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

Relation column search

Similar Threads

Relation column search

Similar Threads

Similar Threads

Similar Threads