FilamentF
Filament•2y ago
daar

Searchable and sortable on polymorph

Hi, how to implement a search based on a polymorphic relation with a relationship one down even?

With the following code I get the error for sorting: Call to a member function getRelated() on null.

On searching I get: 
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.'first_name' like ? or 'consultable'.'patientStatus'.'patient'.'last_name' like' at line 1


Seems like a bug in Filament? The code used is shown below:
Tables\Columns\TextColumn::make('consultable.patientStatus.patient.full_name')
    ->searchable(['consultable.patientStatus.patient.first_name', 'consultable.patientStatus.patient.last_name'])
    ->sortable(['consultable.patientStatus.patient.first_name', 'consultable.patientStatus.patient.last_name']),
Was this page helpful?