/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

26 votes147 views6 answers
Php header location
PHP
0 vote140 views1 answer
Laravel where false
PHP Laravel
0 vote146 views2 answers
How to separate date and time in laravel
PHP Laravel
0 vote189 views1 answer
Laravel change string to text
PHP
1 vote149 views2 answers
Insert data to table in wordpress 2
PHP
0 vote141 views1 answer
Stopping On First Validation Failure
PHP
2 votes129 views2 answers
How to use stored procedure in laravel
PHP
1 vote126 views1 answer
Laravel 8 validation required if another field is not null
PHP
0 vote117 views1 answer
How to change directory in command processor
PHP
0 vote176 views1 answer
Read xml file in php wordpress
PHP Wordpress

Share