martin-ro Comments - Answer Overflow

martin-ro

Posts Comments

FFilament

•Created by nowak on 8/9/2024 in #❓┊help

Duplicate and missing records/rows when navigating table pages

yeah, that's a better description. The default is certainly not expected behaviour, so it's a bug.

13 replies

FFilament

•Created by nowak on 8/9/2024 in #❓┊help

Duplicate and missing records/rows when navigating table pages

Yes, a GH issue with the fix would be a good start so the problem gets visible/searchable for others.

13 replies

FFilament

•Created by nowak on 8/9/2024 in #❓┊help

Duplicate and missing records/rows when navigating table pages

This also works:

TextColumn::make('created_at')
  ->sortable(['created_at', 'id'])

TextColumn::make('created_at')
  ->sortable(['created_at', 'id'])

13 replies

FFilament

•Created by nowak on 8/9/2024 in #❓┊help

Duplicate and missing records/rows when navigating table pages

Yes, meanwhile I have figured it out. The minimal reproducible setup would be a table with ->defaultSort('created_at', 'desc') or a TextColumn::make('created_at')->sortable() with records that have identical created_at timestamps. The way to solve that for me was:

public static function table(Table $table): Table
    {
        return $table
            ->defaultSort('created_at', 'desc')
            ->defaultSort('id', 'desc')
...

public static function table(Table $table): Table
    {
        return $table
            ->defaultSort('created_at', 'desc')
            ->defaultSort('id', 'desc')
...