/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

5 votes299 views3 answers
Get users of specific role laravel role spatie
PHP Laravel
1 vote284 views2 answers
Laravel Cannot add foreign key constraint
PHP Laravel
0 vote316 views1 answer
Laravel app service provider why eloquent model error
PHP Laravel
49 votes336 views6 answers
Laravel clear all cache
PHP Laravel
22 votes278 views6 answers
Laravel log
PHP Laravel
0 vote287 views2 answers
Unique sql queries laravel
PHP Laravel
2 votes234 views1 answer
Comments table example in laravel
PHP Laravel
7 votes305 views3 answers
How to show validation error in laravel blade
PHP Laravel
0 vote275 views1 answer
Unique string faker laravel
PHP Laravel
10 votes295 views3 answers
Migrate to an existing table in laravel commad
PHP Laravel

Share