Laravel. Use scope() in models with relation

by

You can do it inline:

$categories = Category::with(['posts' => function ($q) {
  $q->published();
}])->get();

You can also define a relation:

public function postsPublished()
{
   return $this->hasMany('Post')->published();
   // or this way:
   // return $this->posts()->published();
}

and then:

//all posts
$category->posts;

// published only
$category->postsPublished;

// eager loading
$categories->with('postsPublished')->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 Eloquent “WHERE NOT IN”
  6. How to access model hasMany Relation with where condition?
  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. How to install Laravel 4 to a web host subfolder without publicly exposing /app/ folder?
  16. Laravel Fluent Query Builder Join with subquery
  17. How to Get the Current URL Inside @if Statement (Blade) in Laravel 4?
  18. laravel with() method versus load() method
  19. Laravel Eloquent: How to order results of related models?
  20. Laravel Migration Change to Make a Column Nullable
  21. Laravel Controller Subfolder routing
  22. How to use paginate() with a having() clause when column does not exist in table
  23. Select Last Row in the Table
  24. How to get distinct values for non-key column fields in Laravel?
  25. Where can I set headers in laravel
  26. What is the difference between queue:work –daemon and queue:listen
  27. How to select specific columns in laravel eloquent
  28. Set port for php artisan.php serve
  29. Laravel Eloquent – distinct() and count() not working properly together
  30. Laravel 4 : Route to localhost/controller/action

Leave a Comment