/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

2 votes123 views1 answer
Download speed limit php
PHP
0 vote130 views1 answer
Php check if number between range
PHP
1 vote245 views1 answer
How to setup cronjob on cakephp on share hosting
PHP CakePHP
0 vote131 views1 answer
CAPTURAR URL PHP
PHP
0 vote132 views2 answers
Catch any exception php
PHP
2 votes192 views2 answers
Check if date between two dates laravel eloquent
PHP
-1 vote186 views3 answers
Php tutorial
PHP
0 vote144 views1 answer
Ci base url dynamic
PHP
7 votes140 views3 answers
Laravel creat new model
PHP
106 votes319 views6 answers
Php strlen
PHP

Share