Forum How to get (Client::with->last 10 activities) in one Eloquent collection

posted 9 years ago

Last updated 2 years ago.

replied 9 years ago

If the activity table has created_at fields, you should do order_by

$result = Client::with(['activity' => function ($query) {
     $query->orderBy('created_at', 'desc')->limit(10);
}])->get();

Not sure if it works, didn't tested

replied 9 years ago

@PalTamasWBA This brings only the first 10 activities for the first client.

Not for Each client

replied 9 years ago

What was wrong with JarekTkaczyk's method?

replied 9 years ago

I found the solution with JarekTkaczyk's tweak.

I tried it before but I haven't extended my "Comments" model to "BaseModel", I extended only the "Post" model.

Now , I converted it to a Trait and it's working like a charm

Last updated 9 years ago.

zezont4 zezont4 Joined 7 Oct 2015

We'd like to thank these amazing companies for supporting us

The Laravel portal for problem solving, knowledge sharing and community building.

Laravel.io

Socials

The community