3 replies

Group records in sort order

Hi, Tuto - I have been watching your vet clinic streams lately and have a question. When we group a table, we can dispaly it in ASC or DESC order. But can we add the third parameter - 'sort_order' to the dropdown? Filament offers sorting out of the box and grouping by sort order by default would be nice in one of my projects. Thanks!

tuto1902•12/5/23, 4:42 PM

Have you tried customizing the group query? I think you can add ->orderBy()->orderBy() to the query and that will allow you to have default sorting on your group. I hope that answers your question
https://filamentphp.com/docs/3.x/tables/grouping#customizing-the-eloquent-query-grouping-behaviour

Grouping rows - Table Builder - Filament

KidereoOP•12/5/23, 6:41 PM

Thanks, Tuto - you certainly sent me in the right direction which is to read the documentation! In the end I used Group::make('post.sort_order')Group::make('post.sort_order') and then ->getTitleFromRecordUsing(fn (Comment $record): string => ucfirst($record->post->title))->getTitleFromRecordUsing(fn (Comment $record): string => ucfirst($record->post->title)) to achieve the required effect. Thanks again!

Group records in sort order

Similar Threads

Similar Threads

Similar Threads