Laravel search in has many relation

Question

I have problem with my Laravel project. I have model Post and Comment. One post has many comments and this is relation in my Post comment. When When I want get all posts and comments all works great:

$posts = Post::with('comments')
        ->orderBy('id', 'desc')
        ->paginate(10);

I have problem because I want write search engine to models. I want get only posts and only comments where search condition for comments if true. I try this code:

$posts = Post::with('comments')
        ->whereHas('comments', function($q) use($sort, $search){
            if($sort === 'answered'){
                $q->where('answered', '=', 1);
            }
            if($search){
                $q->where('content', 'like', '%'.$search.'%');
            }
        })
        ->orderBy('id', 'desc')
        ->paginate(10);

But this code return all comments to post, not only comments where condition is true.

you need to add where condition in your with statement to apply filter in relational data not in whereHas. — Bhaumik Pandhi
– Bhaumik Pandhi, Commented Feb 26, 2020 at 10:32

Amal S R · Accepted Answer · 2020-02-26 10:34:49Z

2

You must apply the same condition in with for achieving this. Example,

$posts = Post::with(['comments' => function($q) use($sort, $search) {
       if($sort === 'answered'){
            $q->where('answered', '=', 1);
        }
        if($search){
            $q->where('content', 'like', '%'.$search.'%');
        }
    }])
    ->whereHas('comments', function($q) use($sort, $search){
        if($sort === 'answered'){
            $q->where('answered', '=', 1);
        }
        if($search){
            $q->where('content', 'like', '%'.$search.'%');
        }
    })
    ->orderBy('id', 'desc')
    ->paginate(10);

I think this will solve your issue. and let me know if it is working

answered Feb 26, 2020 at 10:34

Amal S R

9408 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel search in has many relation

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related