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(),

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'

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'modelB_tablename.modelC.id' in 'where clause'

Filament•3y ago•

2 replies

ericmp #2

Sortable - Sort by far relationship

Tables\Columns\TextColumn::make('modelB.modelC.date')
    ->date('d/m/Y H:i')
    ->sortable(),

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'

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'modelB_tablename.modelC.id' in 'where clause'

Sortable - Sort by far relationship

Similar Threads

Sortable - Sort by far relationship

Similar Threads

Similar Threads

Similar Threads