Eloquent oderby using ( with )

Question

client Model

 protected $table = 'client';
    protected $fillable = [
        'client_name',
        'supplier_id'
    ];

 public function supplier()
    {
        return $this->belongsTo(Supplier::class, 'supplier_id', 'id');
    }

Supplier table

id    | supplier
1     | john 
2     | ace
3     | bravo

ClientController

$Client = new Client();
        $Client = $Client ->with(
            'supplier'
        );
 $Client = $Client->orderBy('supplier', 'DESC');

Error

Column not found: 1054 Unknown column 'supplier' in 'order clause' (SQL: select * from `client` order by `supplier` desc limit 20 offset 0)

i need to order by supplier from with relationship

score 0 · Answer 1 · answered Jul 25 '22 at 10:06

0

Depending on your laravel version you can try:

$Client = new Client();
return $Client ->with([
    'supplier' => function ($q){
    $q->orderBy('supplier');
    }
]);

answered Jul 25 '22 at 10:06

Kevin Sada

69
4

hello , thanks for replying but this function didn't work for me + you need to add ->get() in the last of it – Mohammad Mansour Jul 26 '22 at 10:01
which laravel version are you using @MohammadMansour – Kevin Sada Jul 26 '22 at 13:38
laravel version 9 – Mohammad Mansour Jul 27 '22 at 11:46

score 0 · Answer 2 · answered Jul 25 '22 at 11:04

0

If you want to order the supplier inside the Client, see this.

If you want to order the Client based on its supplier, see this.

answered Jul 25 '22 at 11:04

rifqy abdl

156
1
8

score 0 · Answer 3 · answered Jul 25 '22 at 16:09

So, From what I have understood is that you want to orderBy your data based on a relationship's column.

If so, I am not sure if it's easy to do this with Eloquent. Though you can use Query Build as following:

$clientQuery = Client::query();

$clientQuery->selectRaw("clients.*, (SELECT MAX(created_at) from suppliers WHERE clients.supplier_id=suppliers.id) as orderBySupplier")
        ->orderBy("orderBySupplier", "DESC");

Eloquent oderby using ( with )

3 Answers3