Level 9
Take a look at the documentation. There is a whereNotExists on the builder class.
http://laravel.com/api/5.1/Illuminate/Database/Query/Builder.html#method_whereNotExists
Aug 12, 2015
5
Level 5
Query builder 'where does not exist'?
I am try to do this;
select records from table where value A does not exist in table B
I see I can do the opposite with a whereExists statement.
Is there such a thing as a whereDoesNotExist?
Level 5
@jasonfrye thanks, I didn't dig deep enough in the docs.
Any chance you have an example of how this might work?
I have tried this;
$A = Clients::where('value', '1');
$B = Clients::whereNotExists($A, 'other_table')->get();
I get this;
Argument 1 passed to Illuminate\Database\Query\Builder::whereNotExists() must be an instance of Closure, instance of Illuminate\Database\Eloquent\Builder given
Level 56
@Tenzing you are putting a query builder in a function expecting a closure.
Level 9
@Tenzing take a look at this example: http://stackoverflow.com/questions/22409469/laravel-4-where-not-exists
Level 5
@jasonfrye that's it. Thanks!
Please or to participate in this conversation.