Laravel Mongodb groupby

Question

Am trying to pick the last record from the MongoDB using Laravel MongoDB package. I have a many transaction ID in the database in which some are duplicate ID due to some reasons. In that scenario, I need to groupby the transaction id, and sort it according to time and get the last one.

example

transcation_id status timestamps
1              success 
2              success
3              failed
4              success
3              failed
5              success
3              success

So when I am querying I need the transaction_id of 3 as success, which is the last status with the time stamp. However, my query gives me 3 as failed.

$query  = MyCollection::whereIn('app_id' , $appId->toArray())
                ->select(['transcation_id',.....,'created_at'])
                ->orderBy('updated_at')
                ->groupBy('transcation_id')
                ->get();

Please correct me where am doing wrong.

sandip kakade · Accepted Answer · 2017-02-15 07:12:28Z

1

Laravel collections has method last

Model::all() -> last(); // last element

This is the best way to do it.

For better solutions use this doc

answered Feb 15, 2017 at 7:12

sandip kakade

1,3566 gold badges24 silver badges50 bronze badges

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

3 Comments

Arun Code Over a year ago

Does jessenger Laravel MongoDB package supports the last method?

sandip kakade Over a year ago

@ArunCode Yes supports to jessenger also

Arun Code Over a year ago

Tried, the method does not seem to work. Call to undefined method Jenssegers\Mongodb\Query\Builder::last()

Collectives™ on Stack Overflow

Laravel Mongodb groupby

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related