How can i get latest n number of related model records in laravel

Question

I have two tables - Posts and Comments. The relationship between them is one-to-many. A Post has many comments.

I am trying to get a list of all Posts with their latest 2 Comments

I have tried this:

$posts = Post::with(['comments'=>function($query){
    $query->latest()->take(2)->get();
}])->get();

But it seems to be working only for the first Post;

similar issue this might help you. Ref:https://stackoverflow.com/questions/68422673/sub-query-with-eloquent-relationship/68422825#68422825 — John Lobo, Jul 21 '21 at 03:06

score 1 · Accepted Answer · answered Jul 20 '21 at 18:33

Laravel doesn't offer this functionality out of the box as discussed here https://github.com/laravel/framework/issues/18014 and documented here https://laravel.com/docs/8.x/eloquent-relationships#constraining-eager-loads, but there is a package that you can use to achieve this.

1 Answers1