jeudi 16 février 2017

Laravel eloquent limit results

I have a working query:

Object::all()->with(['reviews' => function ($query) {
            $query->where('approved', 1);
        }])

And I want to limit the number of reviews, per object, that is returned. If I use:

Object::all()->with(['reviews' => function ($query) {
            $query->where('approved', 1)->take(1);
        }])

or

Object::all()->with(['reviews' => function ($query) {
            $query->where('approved', 1)->limit(1);
        }])

it limits the total number of reviews, where I want to limit the reviews that are returned by each object. How can I achieve this?



from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2kuN5Jy
via IFTTT

Aucun commentaire:

Enregistrer un commentaire