Laravel: how to eager load 2 models per model

Asked Dec 02 '17 at 11:13

Active Dec 02 '17 at 12:46

Viewed 121 times

I have a shop where people can leave a comment for a product. On the front page I would like to display the 2 best comments for each product. So I want to eager load the best 2 comments for each product when loading the products.

This is what I tried initially:

Product::with(['comments' => function ($query) {
  $query
  ->orderBy('points', 'desc')
  ->limit(2);
}])->get()

Instead of giving me the 2 best comments per product, it only gives me the 2 best comments of all the products.

Do you have any idea how to approach this? Thank you!

edited Dec 02 '17 at 11:19

lagbox

48,571
8
72
83

asked Dec 02 '17 at 11:13

Hillcow

It caused by static method, you use. You are working, but you need Instance. – Piterden Dec 02 '17 at 11:17
Please share datamodel of comments and products table. – macghriogair Dec 02 '17 at 11:19
refer this.. https://stackoverflow.com/questions/22044954/eloquent-eager-loading-constraint-limit – ZeroOne Dec 02 '17 at 11:22
There is no simple way to do that in MySQL. So I don't think there is a way to avoid raw queries. – Paul Spiegel Dec 02 '17 at 11:32
@Piterden what do you mean? – Hillcow Dec 02 '17 at 12:28
@macghriogair It's the most basic setup. Both have id, products have a title and comments a body and points. – Hillcow Dec 02 '17 at 12:29

Laravel: how to eager load 2 models per model

0 Answers0