/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 vote356 views1 answer
Ph address format
PHP
0 vote322 views1 answer
Php print array nice format (multiple arrays)
PHP
1 vote333 views1 answer
Define("ROOT PATH", __DIR__);
PHP
0 vote384 views1 answer
Server error in laravel
PHP Laravel
0 vote342 views1 answer
Deleting a row from databse using php
PHP
1 vote344 views1 answer
Php pdo get database name
PHP
1 vote397 views1 answer
[InvalidArgumentException] Could not find package laravel/laravel with version 7.0 in a version installable using your PHP version, PHP extensions and Composer version.
PHP Laravel
2 votes390 views1 answer
Check if value is not null in db laravel
PHP Laravel
0 vote412 views1 answer
Wp tax_query in
PHP Wordpress
0 vote312 views1 answer
Laravel repository error
PHP

Share