Concat 2 fields in 1 columns and be searchable

Hello. I am showing 2 phone nos in 1 columns using:

TextColumn::make('phone_nos')
                    ->getStateUsing(function ($record) {
                        return $record->phone_no . ' / ' . $record->phone_no02;
                    })
                    ->label(__('phone_nos'))
                    ->searchable()
                    ->toggleable()
                    ->sortable(),

TextColumn::make('phone_nos')
                    ->getStateUsing(function ($record) {
                        return $record->phone_no . ' / ' . $record->phone_no02;
                    })
                    ->label(__('phone_nos'))
                    ->searchable()
                    ->toggleable()
                    ->sortable(),

The problem is only for the search. It throws an error because field "phone_nos" does not exist in the database, obviously. Any suggestions? I need to do this with other kind of info, such as different emails. Tks.

Solution:

https://filamentphp.com/docs/2.x/tables/columns/getting-started#searching

Getting started - Table Builder - Filament

Jump to solution

3 Replies

toeknee•16mo ago

So adjust the query 😉

Solution

toeknee•16mo ago

https://filamentphp.com/docs/2.x/tables/columns/getting-started#searching

Getting started - Table Builder - Filament

Albert LensOP•16mo ago

Thank you very much. Solved.

Gaming

Programming

Concat 2 fields in 1 columns and be searchable