/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 vote265 views1 answer
Codeigniter 3 session not working after some time
PHP CodeIgniter
2 votes215 views1 answer
Laravel required if another field has value
PHP
11 votes229 views2 answers
Select distinct laravel
PHP
0 vote219 views1 answer
Php url variable xss sanitize
PHP
0 vote244 views2 answers
Polymorphism in php
PHP
0 vote222 views2 answers
Phpexcel set data type string
PHP
1 vote259 views1 answer
Integer nullable laravel
PHP Laravel
1 vote212 views1 answer
How import the impliment countable php
PHP
2 votes221 views2 answers
Php do not refresh page after submit post
PHP
7 votes214 views2 answers
Laravel how to check if there are record exists
PHP

Share