/PHP/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 vote368 views4 answers
How to use sweetalert in laravel controller
PHP Laravel
1 vote333 views2 answers
Target class [Barryvdh\Cors\HandleCors] does not exist.
PHP
39 votes335 views6 answers
Create table laravel
PHP Laravel
0 vote340 views1 answer
Laravel eloquent set timestamps values upon seed
PHP
0 vote345 views1 answer
Laravel request except multiple
PHP
0 vote384 views1 answer
Custom timestamp column laravel
PHP Laravel
0 vote317 views2 answers
If condition in smarty
PHP
0 vote339 views2 answers
How to rollback if one table in laravel didn't save data successfully
PHP Laravel
0 vote368 views1 answer
Laravel storage goes to 404 page. (Symlink not working)
PHP Laravel
1 vote324 views1 answer
While loop in laravel
PHP

Share