Laravel Eloquent: How to order results of related models?

Question

I have a model called School and it has many Students .

Here is the code in my model:

public function students() {     return $this->hasMany('Student'); } 

I am getting all the students with this code in my controller:

$school = School::find($schoolId); 

and in the view:

@foreach ($school->students as $student) 

Now I want to order the Students by some field in the students table. How can I do that?

Answer 1

You have a few ways of achieving this:

// when eager loading $school = School::with(['students' => function ($q) {   $q->orderBy('whateverField', 'asc/desc'); }])->find($schoolId);  // when lazy loading $school = School::find($schoolId); $school->load(['students' => function ($q) {   $q->orderBy('whateverField', 'asc/desc'); }]);  // or on the collection $school = School::find($schoolId); // asc $school->students->sortBy('whateverProperty'); // desc $school->students->sortByDesc('whateverProperty');   // or querying students directly $students = Student::whereHas('school', function ($q) use ($schoolId) {   $q->where('id', $schoolId); })->orderBy('whateverField')->get(); 

Answer 2

you can add orderBy to your relation, so the only thing you need to change is

public function students() {     return $this->hasMany('Student'); } 

to

public function students() {     return $this->hasMany('Student')->orderBy('id', 'desc'); }