ordery by descending with foreign key on laravel

Arya Rizky Sandi 0
Viewed 22

i want to sort my data by foreign key in my table. how can i do that?

here's my query

"jenis_pengiriman_id" is my foreign key in biaya_pengiriman table

its BiayaPengirimanController

   public function index()
{
    $biaya_pengiriman = BiayaPengiriman::latest()->get();
    return view('biaya_pengiriman.index', compact('biaya_pengiriman'));
}

its my query for relationship on foreign key

public function jenis()
{
    return $this->belongsTo(JenisPengiriman::class, 'jenis_pengiriman_id');
}

sorry for my bad english

laravel-8 eloquent php laravel
1 Answers

You can use

$biaya_pengiriman = BiayaPengiriman::all()->orderBy('your_field_name', 'DESC')-get();

at the end of your query in your index method. You don't need to do this in your model.

Wakil Ahmed0
Related