F
Filament•3w ago
Matthew

defaultSort() with an enum

Using defaultsort() on an enum column sorts as per the enum value...but the user would be expecting it to sort on the human readable value.... is there a way of overcoming this ?
Solution:
Ok, here is a solution, feels a bit hacky, if anyone has a better one....feel free to tell. In the enum, add a reverse label case method: ``` public static function sortCaseSql(string $column) : string...
Jump to solution
1 Reply
Solution
Matthew
Matthew•3w ago
Ok, here is a solution, feels a bit hacky, if anyone has a better one....feel free to tell. In the enum, add a reverse label case method: 
    public static function sortCaseSql(string $column) : string
    {
        $cases = collect(self::cases())
            ->map(fn (self $case) => "WHEN '{$case->value}' THEN '" . addslashes($case->getLabel()) . "'"
            )
            ->implode(' ');

        return "CASE $column $cases END";
    } 
    public static function sortCaseSql(string $column) : string
    {
        $cases = collect(self::cases())
            ->map(fn (self $case) => "WHEN '{$case->value}' THEN '" . addslashes($case->getLabel()) . "'"
            )
            ->implode(' ');

        return "CASE $column $cases END";
    }
In the resource, add a virtual column: 
   public static function getEloquentQuery() : Builder
    {
        return parent::getEloquentQuery()
            ->select('*')
            ->selectRaw(enumKbGroup::sortCaseSql('kb_group') . ' as kb_group_label');
    }
   public static function getEloquentQuery() : Builder
    {
        return parent::getEloquentQuery()
            ->select('*')
            ->selectRaw(enumKbGroup::sortCaseSql('kb_group') . ' as kb_group_label');
    }
In the table, just use the virtual column as you would anyway: 
         TextColumn::make('kb_group_label')
                ->label('Category')
                ->badge()
                ->sortable(),
         TextColumn::make('kb_group_label')
                ->label('Category')
                ->badge()
                ->sortable(),
and same in the table method: ->defaultSort('kb_group_label', 'asc')

Did you find this page helpful?