Sortable relation...

Hello everyone!

This works:

Tables\Columns\TextColumn::make('user.lastname')->sortable()

Tables\Columns\TextColumn::make('user.lastname')->sortable()

Tables\Columns\TextColumn::make('user.lastname')->sortable()

Tables\Columns\TextColumn::make('user.lastname')->sortable()

This obviously does not work:

Tables\Columns\TextColumn::make('user.full_name')->sortable()

Tables\Columns\TextColumn::make('user.full_name')->sortable()

Tables\Columns\TextColumn::make('user.full_name')->sortable()

Tables\Columns\TextColumn::make('user.full_name')->sortable()

full_name

full_name

full_name

full_name is a combination of

lastname

lastname

lastname

lastname and

firstname

firstname

firstname

firstname.

How should I proceed? Should I create a scope since it's in a relationship?

Any help? Thanks in advance!