Laravel Eloquent Filter By Column of Relationship

Question

Using the Eloquent ORM I have my models set up like so: Post belongsToMany Category

Post.php

public function categories()
{
    return $this->belongsToMany('Category', 'posts_categories');
}

I want to filter posts by a column of the categories relationship.

So I want to do something like:

$posts->where('categories.slug', '=', Input::get('category_slug'));

This doesn't work though.

I also tried:

$with['categories'] = function($query){ 
    $query->where('slug', '=', Input::get('category_slug'));
};

$posts::with($with)->get();

But I thnk that's for filtering the categories not filtering BY the category.

Can anyone show me the way?

score 107 · Accepted Answer · answered Dec 27 '13 at 14:42

107

I can't access my Vagrant box right now, but I believe this should work:

$posts = Post::whereHas('categories', function($q)
{
    $q->where('slug', '=', Input::get('category_slug'));

})->get();

answered Dec 27 '13 at 14:42

petkostas

1

Works great! Had to upgrade to Laravel v4.1 though as this is a new feature – iamjonesy Dec 27 '13 at 15:53
Thanks a ton. I’ve spend hours trying to figure this out and finally solved it! :O – Saifur Rahman Mohsin Sep 21 '15 at 20:02
Exactly what I needed! – J Foley Apr 24 '17 at 13:10
3

whereHas does a full table scan. For small tables this is fine if say (categories) ha 100,000 rows then this will drastically be slow. How do you go about that then? – Cengkuru Michael Jun 29 '17 at 04:40
`whereHas` filters out the non-nelationship results. Any way to not filter the null relationship results? – Dr. House Aug 15 '21 at 20:25

score 5 · Answer 2 · answered Nov 13 '21 at 07:33

5

Here's a quick way to filter on related model column:

$allConsultants = Consultant::whereHas('user', function($query)
{
    $query->where('is_approved', '=', 1);

})->get();

answered Nov 13 '21 at 07:33

hackernewbie

2 Answers2