How to access model hasMany Relation with where condition?

by

I think that this is the correct way:

class Game extends Eloquent {
    // many more stuff here

    // relation without any constraints ...works fine 
    public function videos() {
        return $this->hasMany('Video');
    }

    // results in a "problem", se examples below
    public function available_videos() {
        return $this->videos()->where('available','=', 1);
    }
}

And then you’ll have to 

$game = Game::find(1);
var_dump( $game->available_videos()->get() );

More Related Contents:

  1. Migration: Cannot add foreign key constraint
  2. Laravel Eloquent groupBy() AND also return count of each group
  3. Eloquent Collection: Counting and Detect Empty
  4. Eloquent eager load Order by
  5. Laravel. Use scope() in models with relation
  6. Laravel Eloquent “WHERE NOT IN”
  7. Eloquent push() and save() difference
  8. Laravel save / update many to many relationship
  9. First Or Create
  10. Laravel: Returning the namespaced owner of a polymorphic relation
  11. Polymorphic Eloquent relationships with namespaces
  12. Clone an Eloquent object including all relationships?
  13. Laravel – Eloquent “Has”, “With”, “WhereHas” – What do they mean?
  14. Laravel Check If Related Model Exists
  15. Laravel Eloquent vs DB facade: Why use Eloquent and decrease performance? [closed]
  16. How to Get the Current URL Inside @if Statement (Blade) in Laravel 4?
  17. laravel with() method versus load() method
  18. Laravel Eloquent: How to order results of related models?
  19. Laravel – Forbidden You don’t have permission to access / on this server
  20. How to set a default attribute value for a Laravel / Eloquent model?
  21. How to use paginate() with a having() clause when column does not exist in table
  22. Select Last Row in the Table
  23. Laravel Eloquent – Attach vs Sync
  24. What is the difference between queue:work –daemon and queue:listen
  25. How to create a subquery using Laravel Eloquent?
  26. Eloquent model mass update
  27. Set port for php artisan.php serve
  28. Laravel Eloquent – distinct() and count() not working properly together
  29. How can I query raw via Eloquent?
  30. Laravel 4 : Route to localhost/controller/action

Leave a Comment