Question 8148 in PHP Versions Question posted in
You can find a list of all versions here.

How do I display the highest value of the column in Laravel using Eloquent? – PHP Versions

I am trying to display rows that show the highest Version of each Name. However, I’m having problems on how to convert my raw php code to Eloquent ORM. Any help will be appreciated.

$sql="SELECT * FROM images WHERE (Name,Version) IN (SELECT Name, MAX(Version) FROM images GROUP by Name)";

Edit:

This is my code that I tried so far, it shows unique names but it doesn’t show the name’s highest version.

$items=Item::orderBy("version","DESC")->groupBy('model_name')->latest()->paginate(5);
Tags:

2

Answers


  1. 0

    You can try with:

    Images::max('Version');

    You can find more about aggregates here

    Login or Signup to reply.
  2. 0 
    Image::all()
->groupBy('model_name')
->map(function($group) { return $group->sortByDesc('version')->first(); });

    Image::all()

    You know what it does.

    ->groupBy(‘model_name’)

    Group by model_name. Replace the field name with by which field you want to group them. So there are how many models, there are that many group(s).

    ->map(function($group) { return $group->sortByDesc(‘version’)->first(); });

    In each group, to get the item (not items) latest version, I’m sorting them descending by version. This way item with the latest version will be at the top. Then take it.

    If you want multiple items with the latest version, adapt.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search