WhereNotExists Laravel Eloquent WhereNotExists Laravel Eloquent laravel laravel

WhereNotExists Laravel Eloquent


php laravel eloquent

Try this:

$repairJobs = RepairJob::with('repairJobPhoto', 'city', 'vehicle')              ->where('active', '=', 'Y')              ->whereNotExists(function($query)                {                    $query->select(DB::raw(1))                          ->from('DismissedRequest')                          ->whereRaw('RepairJob.id = DismissedRequest.id');                })->get();

php laravel eloquent

Try doesntHave() method. Assuming 'dismissedRequests' as relation name in RepairJob model.

$jobs = RepairJob::with('repairJobPhoto', 'city', 'vehicle')    ->where('active', 'Y')->doesntHave('dismissedRequests')->get();

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last