/PHP/Laravel/Laravel query order by relation

Laravel query order by relation

Laravel query order by relation

$order = 'desc';
$users = User::join('roles', 'users.role_id', '=', 'roles.id')->orderBy('roles.label', $order)->select('users.*')->paginate(10);

1

Source: laracasts.com

Laravel OrderBy on Eloquent whereHas relationship

$counties = County::whereHas('items', function ($query) {
    $query->where('approved', 1);
})->orderBy('name')->get();

0

Source: stackoverflow.com

Laravel orderby with relation

$users = User::with(['student' => function ($q) {
            $q->orderBy('id', 'desc');
        }]);

-1

Source: laracasts.com

Similar codes

0 vote308 views1 answer
Laravel permission spatie cache clear
PHP Laravel
10 votes303 views2 answers
Create model in laravel command line
PHP Laravel
24 votes319 views2 answers
Clear laravel cache and clear vue
PHP Laravel
0 vote300 views1 answer
Laravel custom validation check if valid url
PHP Laravel
0 vote317 views1 answer
Laravel new line in language file
PHP Laravel
11 votes272 views4 answers
Laravel validator make custom message
PHP Laravel
0 vote364 views1 answer
Laravel joins eloquent model
PHP Laravel
0 vote290 views1 answer
Laravel collection nth method
PHP Laravel
0 vote305 views2 answers
Laravel log could not be opened fix
PHP Laravel
11 votes326 views2 answers
Laravel mass update relationship
PHP Laravel

Share