Laravel 4 Eager Loading constraints

Question

I want to get all Items (topics) WITH their comments, if comments user_id = $id. I try something like this, but it isn't working. So if Item hasn't got any comment with user_id = $id, then I don't need this Item.

In DiscussionsItem model I have methode:

public function discussionsComments() {
    
    return $this->hasMany('DiscussionsComment', 'discussionsitem_id');
}

My query in controller is like this:

    $items = DiscussionsItem::whereBrandId($brand_id)
        ->whereBrandCountryId($country_id)
        ->with(['discussionsComments' => function($query) use ($id) {
            $query->where('user_id', '=', $id);
        }])
        ->whereHas('discussionsComments', function($query) use ($id) {
            $query->where('user_id', '=', $id);
        })
        ->with(['views' => function($query) use ($id) {
            $query->where('user_id', $id)->count();
        }])
        ->orderBy('created_at', 'DESC')->get();

My problem is that I get items with comments, where comments user_id != $id.

P.S. I need to take 5 comments, but I cant imagine how to do that, because ->take(5) in my eager load is not working.

This is how you do it: http://softonsofa.com/tweaking-eloquent-relations-how-to-get-n-related-models-per-parent/ in MySQL — Jarek Tkaczyk, Jan 21 '15 at 22:57
Does this answer your question? [Laravel eager loading with limit](https://stackoverflow.com/questions/33607088/laravel-eager-loading-with-limit) — miken32, Dec 07 '21 at 17:51

score -1 · Answer 1 · answered May 06 '15 at 19:19

-1

You can do a custom scope, or just limit the amount returned by your relation:

public function discussionsComments() {
    return $this->hasMany('DiscussionsComment', 'discussionsitem_id')
        ->latest()
        ->take(5);
 }

answered May 06 '15 at 19:19

Robert

5,703
2
31
32

Laravel 4 Eager Loading constraints

1 Answers1