Laravel 5.1: Eloquent relationship hasMany, Limit records

Shouldn't that be paginate(5);

->with(['comments'=>function($query) {
    return $query->limit(5);
}])

I didn't tested, but this should work fine.

Edit¹: tested, it works fine on L5.0 and should work on L5.1

Edit²: Sorry, It does not works when loading multiple items as you are asking. This way only work if you load a single item.

I have tried, but haven't sucessed yet.

@tronghiep92 You can't limit the result of eager loading data :)

@tronghiep92 Hey.

Try this:

return Feed::whereUserId($userId)->with(['comments' => function($q) {
    $q->take(5);
}])->get();

@tronghiep92 There isn't an easy way to do this. @JarekTkaczyk posted a solution a while ago though. Try it out because it's exactly what you're looking for.

http://softonsofa.com/tweaking-eloquent-relations-how-to-get-n-related-models-per-parent/

@kfirba It will limit feed item too :)

@thomaskim Thanks for mentioning :)

@tronghiep92 the link pasted by thomas is showing how to do that in MySQL. However, your approach is right as well, just mind that you cannot directly assign relation:

// instead of this:
$feed->comments = $feed->comments->take(5);

// do this:
$feed->setRelation('comments', $feed->comments->take(5));

@JarekTkaczyk just found your article and was about to post it here :)

Anyways, why can't he directly set the relation? Does laravel use a magic method in order to fetch the relations? If so, why won't it use a magic method to set it?

@kfirba Oh, it will certainly use magic method! However it won't do what you (OP) would expect :)

Let me show you by example:

// let's get a model with related collection
>>> $post = App\Models\Post::with('comments')->first()
=> App\Models\Post {#715
     id: 1
     comments: Illuminate\Database\Eloquent\Collection {#719
       all: [
         App\Models\Comment {#722
           id: 287
         }
         App\Models\Comment {#723
           id: 382
         }
       ]
     }
   }

// let's try to assign something else to the relation
>>> $post->comments = []
=> []

// now get it (hmm looks fine):
>>> $post->comments
=> []



// BUT, in fact it just gets this:
>>> $post->getAttribute('comments')
=> []

// while relation remains intact:
>>> $post->getRelation('comments')
=> Illuminate\Database\Eloquent\Collection {#719
     all: [
       App\Models\Comment {#722
         id: 287
       }
       App\Models\Comment {#723
         id: 382
       }
     ]
   }
>>> 

@JarekTkaczyk oh I see. You learn something new every day ;) thanks!

I had same issue and I did this,

$data['categories'] = Category::where('is_active', 1)
    ->take(4)
    ->orderBy('id', 'DESC')
    ->get();

then in Category model,

public function posts()
{
    return $this->hasMany('App\Models\Post', 'cat_id')->take(4);
}

Not sure its the right way to do but solved my problem.

I hope that helps.

I had same problem, trying to get 2 trips for each company. I am using Laravel 5.6 and I'm not sure if I should posted on here. But this was the first result it came up when i search for a solution. I found a way, works for me, in L5.6.

  public function getFeed($user_id)
    {
        return Feed::whereUserId($user_id)->take(10)->get()->each(function($feed) {
            $feed->load('feed_comments');
        });

    }

model:

    public function comments() {
        return $this->hasMany(Comment::class);
    }

    public function feed_comments() {
        return $this->comments()->take(2);
    }

Thanks @itzursai it worked as expected

If there has another dot notation for nested relation like this

comments.vote

then how can set limit for comments

Thanks @itzursai, helped a lot!