Sort by Laravel polymorphic relationship column

Question

I need to sort the results by column distance relationship between order and address by paging the results.

Order:

public function address()
{
    return $this->morphOne(Address::class, 'addressable');
}

Address:

public function addressable()
{
    return $this->morphTo();
}

I tried the way down but didn’t order:

$orders = Order::with(['address' => function ($query) {
    $query->orderBy('distance', 'asc');
}])->paginate(15)

Answer 1

I managed to solve it. For those who need it, I did it this way:

$orders = Order::with('address')->orderBy(function ($query) {
    $query->select('distance')
        ->from('addresses')
        ->whereColumn('addressable_id', 'orders.id')
        ->limit(1);
})->paginate(15);

Source: https://laravel-news.com/eloquent-subquery-enhancements?fbclid=IwAR3b6Yju4fRGpD8RnLt4Ncjx2cRfbDkoBYysR_-gscyZoAqJZWkFacCPTb8