Laravel limit eager loading for each model

Question

With our User model we are eager loading conversations and messages of these conversations. Of each conversation, we would like to lead the last 25 messages. So we wrote the following query.

User::where('status', 3)->with(['conversations.messages' => function ($q) {
    $q->take(25)->orderBy('created_at', 'DESC');
}])->get();

However, this function only returns 25 messages in total (so not per conversation). Even if you have a 1000 users it will load the last 25 messages in the messages table but not the last 25 per conversation of a user.

Is there a way to solve this within the Laravel Eloquent methodology?

Possible duplicate of [Laravel 5.1 use limit in with() method of eloquent](https://stackoverflow.com/questions/34082082/laravel-5-1-use-limit-in-with-method-of-eloquent) — thisiskelvin, Dec 18 '18 at 16:56
Does this answer your question? [Laravel eager load function limit](https://stackoverflow.com/questions/41664645/laravel-eager-load-function-limit) — Hafez Divandari, Dec 01 '20 at 11:39

score 8 · Accepted Answer · edited Dec 07 '21 at 18:04

There is no native support for this in Laravel.

I created a package for it: https://github.com/staudenmeir/eloquent-eager-limit

Use the HasEagerLimit trait in both the parent and the related model.

class Conversation extends Model {
    use \Staudenmeir\EloquentEagerLimit\HasEagerLimit;
}

class Message extends Model {
    use \Staudenmeir\EloquentEagerLimit\HasEagerLimit;
}

Then simply chain ->take(25) call to your eager-load query (which seems you already do).

You could even use ->offset(...) and ->skip(...) (see repository readme for details).

Laravel limit eager loading for each model

1 Answers1

Linked

Related