Can not use where clause after using with clause in Laravel query

Question

I am writing a query using with and then where clause in laravel.

 $users = User::query()->with('roles')->where('name', '!=', 'customer')->get(); return $users;

But where clause is not working here. Customers are not excluded. I am providing the snap shot of the query result.

where() clause is working here for your users table, not for the roles table — STA
– STA, Commented Feb 1, 2021 at 15:11
The where is only on the User query, not the Roles query. If you want it on the roles query, you'll need to pass it in as a closure. laravel.com/docs/8.x/… — aynber
– aynber, Commented Feb 1, 2021 at 15:11

STA · Accepted Answer · 2021-02-01 15:25:52Z

4

I think you need whereHas() :

use Illuminate\Database\Eloquent\Builder; $users = User::query() ->with('roles') ->whereHas('roles', function (Builder $query) { $query->where('name', '!=', 'customer'); }) ->get(); return $users;

edited Feb 1, 2021 at 15:25

answered Feb 1, 2021 at 15:14

STA

35.3k9 gold badges49 silver badges62 bronze badges

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

2 Comments

Abhijit Mondal Abhi Over a year ago

One question why we are using Builder before the query. Without declaring Builder it also works fine. @sta

Tpojka Over a year ago

@AbhijitMondalAbhi It's called type hinting. Object of class/interface is forced so no other object types can be provided. Safety measure. Also, query()-> can be skipped.

Artem Tumanov · Accepted Answer · 2021-02-01 15:14:14Z

I suppose you trying to filter relation data in base query. Try smth like that:

$users = User::query()->with([ 'roles' => function ($q) { $q->where('name', '!=', 'customer'); }]) ->get(); return $users;

Doc

This is excluding customers. But, it returns all Users which doesn't have the roll customer.

Collectives™ on Stack Overflow

Can not use where clause after using with clause in Laravel query

2 Answers 2

2 Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Related