Laravel aggregate eloquent max result

Question

Here is what i'm trying to do:

I'm implementing a version_id in my vendors table. I'm trying to construct a query to get the index page working. So i'm looking to get all of the vendors from my database that have the latest version_id (max('version_id'). Can't seem to figure it out. Here is what I have so far:

$vendors = $this->account->vendors()->where('version_id', max(version_id))

        ->orderBy($this->orderBy, $this->sortBy)
        ->paginate($this->display_per_page);

I tried this before, but it also gives me errors:

$vendors = $this->account->vendors()->max('version_id')

            ->orderBy($this->orderBy, $this->sortBy)
            ->paginate($this->display_per_page);

It works if I just have this:

$vendors = $this->account->vendors()
            ->orderBy($this->orderBy, $this->sortBy)
            ->paginate($this->display_per_page);

Been looking online but I only find suggestions for queries with joins and such, which is not what i'm looking for. Any help is appreciated!

DevK · Accepted Answer · 2018-05-06 20:24:06Z

2

This should work:

$vendors = $this->account->vendors()
    ->whereRaw('version_id = (SELECT MAX(version_id) from vendors)')
    ->orderBy($this->orderBy, $this->sortBy)
    ->paginate($this->display_per_page);

Assuming table name vendors

answered May 6, 2018 at 20:24

DevK

10k2 gold badges33 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

max234435 Over a year ago

The only issue i'm having now is that is only return one record....how can I make it return highest version_id from that particular vendor. So many vendors only returning highest id in each group

DevK Over a year ago

Are you sure you don't only have 1 vendor bound to this specific account with the max version_id? This shouldn't limit the number of results.

max234435 Over a year ago

So when I add two separate records and both version_id on records show 1 the query gives me multiple results. As soo as I edit one of the records which puts version_id to 2, it only gives me version_id 2 record and shows 1 record

max234435 Over a year ago

I think i might need to add some kind of vendor_code field and group the result by a vendor_code so it gives me the max(version_id) from that vendor_code. Thoughts?

DevK Over a year ago

Oh okay, I see what you need now. Yeah, I think you'll need some kind of grouping for that. I'll think about it a bit, don't have the solution right now

|

Collectives™ on Stack Overflow

Laravel aggregate eloquent max result

1 Answer 1

8 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related