Eager loading aggregate functions of nested relations

[l-alexandrov]

I want to eager load some aggregate function like withMin of a nested relation, but it is not possible.

Let's imagine we have the following models:

• Author - hasMany Posts
• Post - hasMany Comments
• Comment

I want to execute the following query:
Author::withMin('posts.comments', 'rating')->get().

[sbc640964]

I also want!

[erikn69]

Maybe this

Author::withMin('rating')->with(['posts'=>function($query){
    $query->withMin('comments')->groupBy('author_id');
}])->get()

[erikn69]

@sbc640964 just fix it, i'am on a cellphone, not on an editor

Author::with(['posts'=>function($query){
    $query->withMin('comments','rating')->groupBy('author_id');
}])->get()

Maybe better with has-many-through comments, example:

Author::withMin('comments','rating')->get()

[sbc640964]

It works beautifully
But I get all the posts and ratings of everyone

What about I want to get the calculation of the author's rating by calculating the rating of all the posts (without getting all the posts themselves)

[erikn69]

@did you try Author::withMin('comments','rating')->get(), seems to be closer to what you are looking for

[sbc640964]

The problem is that the relationship of the comments is to the posts and not to the authors

[erikn69]

Maybe better with has-many-through comments, example:

did you read the documentation?

[sbc640964]

@erikn69
It can not work.
withMin must have two parameters (relationship and column)