how to sort query results with nested relation column field in laravel?

Question

$props = Property::with(['rentalUnit','rentalUnit.floor'])->get()->toArray();

I want to sort rentalunit collection with field of floor table field floor_name

Any help would be appreciated

Possible duplicate of Laravel Eloquent sort by relation table column — Maraboc
– Maraboc, Commented Sep 25, 2017 at 10:54

Morteza Rajabi · Accepted Answer · 2017-09-25 11:14:05Z

0

Add this to your Property model

public function rentalUnitOrderByFloorName() 
{
    return $this->rentalUnit()->select('rental_units.*', 'floors.name')->leftJoin('floors', 'floors.rental_unit_id', '=', 'rental_units.id')->orderBy('floors.name');
}

Then

$props = Property::with(['rentalUnitOrderByFloorName','rentalUnitOrderByFloorName.floor'])->get()->toArray();

edited Sep 25, 2017 at 11:14

answered Sep 25, 2017 at 10:55

Morteza Rajabi

2,9232 gold badges28 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Morteza Rajabi Over a year ago

In this situation, make a join!

Nikunj Php Over a year ago

if i am applying join than it removing some rows from results i want

Morteza Rajabi Over a year ago

Left join won't do that!

Nikunj Php Over a year ago

i have already try with it left join but i want it without join

Collectives™ on Stack Overflow

how to sort query results with nested relation column field in laravel?

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related