Sorting and searching on relationships

[Der-Kai-T]

I've got a model OrderHistory with a relationship to an item and a size. Both are belongs_to relationships. What's currently working is displaying the correct data in the table using an anonymous column.

For example

Column::make(__("size"))
    ->label(function ($row, Column $column) {
        if(is_null($row->size->size)){
            return "--";
        }
        return $row->size->size;
    })
    ->sortable(),

is showing the correct data. Although I've set ->sortable() it doesn't sort. I've got to put a callback inside the function (according to #2023). But I can't wrap my head around how to construct such callback. I've taken inspiration from some posts on stackoverflow and laracasts. But the Problem is, that I always get an "Column not Found" error.

  public function builder(): Builder
    {
        return OrderHistory::query()
            ->where("history_id", $this->order->id)
            ->with("item");
    }

//column
Column::make(__("item"))
->label(function ($row, Column $column) {
    return $row->item->name;
})
->sortable(fn(Builder $query, string $direction) => $query->orderBy("item.name", $direction)),

I seem to be missing something.

[lrljoe]

Apologies, I've been aware. For your sortable callback, you need to specify the actual table and field within your database that you want to sort by.