Sorting on Anonymous columns?

[mallanza]

Wondering if I there is a way to do ->sortable() on Anonymous column?

Column::make('DPM')
                ->sortable()
                ->searchable()
                ->collapseOnMobile()
                ->label(fn ($row, Column $column) =>
                (($row->total_mileage>0 || $row->other_mileage>0) && $row->amount_invoice>0) ? $row->amount_invoice / ($row->total_mileage + $row->other_mileage) : 0),

[lrljoe]

Absolutely, you can use a callback in "sortable"

e.g. sorting by "amount_invoice"

Column::make('DPM')
  ->label(fn ($row, Column $column) =>
  (($row->total_mileage>0 || $row->other_mileage>0) && $row->amount_invoice>0) ? $row->amount_invoice / ($row->total_mileage + $row->other_mileage) : 0)
    ->sortable(
        fn(Builder $query, string $direction) => $query->orderBy('amount_invoice', $direction)
    ),