/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 vote328 views1 answer
SetUp() must be compatible with Illuminate\Foundation\Testing\TestCase::setUp()
PHP
1 vote286 views2 answers
Get_user_meta
PHP
66 votes325 views5 answers
Cut string in php
PHP
3 votes294 views3 answers
Php max_execution_time
PHP
0 vote304 views1 answer
$this- attribute laravel
PHP Laravel
1 vote341 views2 answers
Use multiple database in laravel
PHP Laravel
1 vote299 views1 answer
How to display user id from a function on a wordpress page
PHP
0 vote361 views1 answer
Laravel excel set cell height
PHP Laravel
0 vote373 views1 answer
Laravel vue error 500
PHP Laravel
21 votes390 views5 answers
Php convert to string
PHP

Share