How to use Table sortable() with Translatable?

I have a json column Translatable Model, how do set the order by/sortable()'

Tables\Columns\TextColumn::make('name')
                    ->sortable()
                    ->searchable(),

Tables\Columns\TextColumn::make('name')
                    ->sortable()
                    ->searchable(),

sortable() doesn't play nice with it, I am using :Spatie Translatable

1 Reply

SLy•11mo ago

Try something like:

 ->sortable(query: fn (Builder $query, string $direction): Builder => $query->orderBy(
                        Model::select('name->' . $table->getLivewire()->activeLocale),
                        $direction,
                    )),

Gaming

Programming

How to use Table sortable() with Translatable?