How to combine multiple WHERE condidtions in WITH and WHEREHAS in Laravel Eloquent query

Question

In below query the awarded, banned, featured and published parts are being ignored, why?

Query: Show me a list of all featured published books with an author that has been awarded and has not been banned.

$books = myBooks::with('authors')
            ->whereHas('authors', function ($query) {
                $query
                    ->where([
                        'awarded' => true,
                        'banned' => false
                    ]);
            })
            ->where([
                'featured' => true,
                'published' => true
            ])
            ->latest()
            ->get();

Does this answer your question? [How to Create Multiple Where Clause Query Using Laravel Eloquent?](https://stackoverflow.com/questions/19325312/how-to-create-multiple-where-clause-query-using-laravel-eloquent) — steven7mwesigwa, Nov 13 '22 at 21:03
[Laravel multiple WHERE clauses](https://stackoverflow.com/questions/43693136/laravel-multiple-where-clauses) — steven7mwesigwa, Nov 13 '22 at 21:13
[Where Clauses](https://laravel.com/docs/9.x/queries#where-clauses) — steven7mwesigwa, Nov 13 '22 at 21:22

score 1 · Answer 1 · answered Nov 13 '22 at 21:02

I don't see the syntax you are using documented anywhere. You can try doing:

$books = myBooks::with('authors')
            ->whereHas('authors', function ($query) {
                $query
                    ->where([
                        [ 'awarded', '=', true ],
                        [ 'banned',  '=', false ]
                    ]);
            })
            ->where([
                [ 'featured', '=', true ],
                [ 'published', '=', true ]
            ])
            ->latest()
            ->get();

you can also use the `withWhereHas()` instead of using the `with` and `whereHas` separately. which do the same. https://laravel.com/docs/9.x/eloquent-relationships#constraining-eager-loads-with-relationship-existence — xenooooo, Nov 14 '22 at 01:11

score 0 · Answer 2 · answered Nov 13 '22 at 20:54

Most likely some of these fields: awarded, banned, featured and published are present in both of your tables. For the query to work correctly in the conditions you need to specify the ownership of these fields

$books = Books::with('authors')
    ->whereHas('authors', function ($query) {
        $query
            ->where([
                'authors.awarded' => true,
                'authors.banned' => false,
            ]);
    })
    ->where([
        'books.featured' => true,
        'books.published' => true,
    ])
    ->latest()
    ->get();

How to combine multiple WHERE condidtions in WITH and WHEREHAS in Laravel Eloquent query

2 Answers2