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.

score 0 · Answer 2 · answered Sep 24 '22 at 11:37

If your n stays constant, for example: getting the latest 3 comments, you can set up the relation in the model this way:

public function latestComments() {
    return $this->hasMany(Comment::class)->latest()->take(3);
}

In your controller, you can simply use:

$posts = Post::with('latestComments')->get();

If your n keeps changing, you can follow this thread: Link

2 Answers2