Sorting users through relation in laravel

Question

i want to sort the users through voornaam(firstname). but im getting the data via a relation.

How do i make my query so that, the relation users are sorted by firstname by alphabet

my function:

public function sortfirstname($id) {
    $ingeschrevenspelers = UserToernooi::with('users')->where('toernooiid', '=', $id)->get()->all();
 //This query ^^


    $toernooi = Toernooi::findOrFail($id);

    dd($ingeschrevenspelers);
    return view('adminfeatures.generatespelerslijst', compact('ingeschrevenspelers', 'toernooi'));
}

What i want to sort

any help is appreciated

thanks in advance

Pistachio · Accepted Answer · 2016-09-12 09:42:57Z

2

Writing code in your own language doesn't make it very easy for other developers to understand your code.

That being said, you can try the orderBy() method on your relationship

In your model where you define the relationship:

public function relationship() 
{
    return $this->belongsTo(SomeClass::class)->orderBy('name', 'DESC');
}

answered Sep 12, 2016 at 9:42

Pistachio

1,6623 gold badges18 silver badges39 bronze badges

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

Comments

Gaurav Gangopadhyay · Accepted Answer · 2016-09-13 13:01:35Z

1

Don't fire all() function at the end thus obtaining a Collection instance of result

//query without the all function
$ingeschrevenspelers = UserToernooi::with('users')->where('toernooiid', '=', $id)->get();

//
$ingeschrevenspelers = $ingeschrevenspelers->sortBy('users.firstname');

answered Sep 13, 2016 at 13:01

Gaurav Gangopadhyay

1,9432 gold badges15 silver badges29 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:22:52Z

1

An alternative to Jordy Groote's answer if you do not want to modify the Model class itself, you can query it with a closure.

$ingeschrevenspelers = UserToernooi::with(['users' => function($q) {  
    $q->orderBy('voornaam', 'asc');
}])->where('toernooiid', '=', $id)->get()->all();

Reference: https://laravel.com/docs/5.3/eloquent-relationships#constraining-eager-loads

Sidenote: I don't think you need a ->all() when you already did a ->get()

edited May 23, 2017 at 12:22

CommunityBot

11 silver badge

answered Sep 12, 2016 at 10:08

Mosufy

1513 bronze badges

2 Comments

Rubberduck1337106092 Over a year ago

Thanks this should work also, thank you for helping. but Max was first to answer so his answer is checked as best answer.

Mosufy Over a year ago

lol. Max was the last to answer. But its cool. Max's answer seem simpler if it gives your expected result

Akshay Vaghasiya · Accepted Answer · 2016-09-12 10:09:31Z

0

$ingeschrevenspelers = UserToernooi::with(['users' => function($query){
    $query->orderBy('voornaam', 'asc');
}])->where('toernooiid', '=', $id)->get()->all();

answered Sep 12, 2016 at 10:09

Akshay Vaghasiya

1,65710 gold badges39 silver badges61 bronze badges

1 Comment

Rubberduck1337106092 Over a year ago

Thanks this should work also, thank you for helping. but Max was first to answer so his answer is checked as best answer.

Collectives™ on Stack Overflow

Sorting users through relation in laravel

4 Answers 4

Comments

Comments

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related