FilamentF
Filament•3y ago
ericmp #2

Sortable - Sort by far relationship

I have model A
Which has a relationship with a pivot, model B
The pivot has a relationship with another model, model C

In my filament table, which has model A as model for the query, I try to sort by an attribute of the model C
Tables\Columns\TextColumn::make('modelB.modelC.date')
    ->date('d/m/Y H:i')
    ->sortable(),

but i get:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'modelB_tablename.modelC.id' in 'where clause'
Was this page helpful?