Laravel Issue : Call to a member function addEagerConstraints() on string in file C:\xampp\htdocs\F5_Venuu\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php

i am getting error:Call to a member function addEagerConstraints() on string in file C:\xampp\htdocs\F5_Venuu\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php

Venue.php

public function reviews()
    {
        return $this->hasMany(Rating::class);
    }
    public function avgrate()
    {
        return $this->reviews()->avg('rating');
    }

Rating.php

  public function venue()
    {
        return $this->belongsTo(Venue::class);
    }

in my controller I am using

return Venue::with('avgrate')->get()

I want to get each Venue model entry with average rating. Kindly Help.

tisuchi

3 years ago

Level 70

@hamo_dev Make sure that your tables have the right conventional relationship column name.

Otherwise set the column custom column name in the relationship.

For example-

public function reviews()
{
        return $this->hasMany(Rating::class, 'foreign_key', 'localKey');
}

The same goes for venue() relationships if the foreign key column name doesn't follow the convention.

Sinnbeck

3 years ago

Level 102

with() is use to load relationships. This isnt a relationship.. its a string

 public function avgrate()
    {
        return $this->reviews()->avg('rating');
    }

hamo_dev

3 years ago

Level 1

@Sinnbeck solution?

Sinnbeck

3 years ago

Level 102

@hamo_dev You can do this https://laravel.com/docs/9.x/eloquent-relationships#other-aggregate-functions

return Venue::withAvg('reviews', 'average')->get()

Please or to participate in this conversation.