Create a query in Eloquent

Question

Navigation

#1 by (3 votes)

1

How can I convert this query to eloquent (I've tried it and I ask to ask since I have no idea)

select  id from solicitudes where id  not in (select autorizaciones.solicitud_id from autorizaciones)

laravel eloquent

asked by jose angarita 01.03.2018 в 23:07

source

1 answer

Doubt with POO exercise in Java - problem with array C # format of a cell in excel

score 3 · Answer 1

This can be worth to you:

DB::table('solicitudes')
    ->select('id')
    ->whereNotIn('id', DB::table('autorizaciones')->pluck('id'))
    ->get();

With models:

Solicitud::select('id')
        ->whereNotIn('id', Autorizacion::pluck('id'))
        ->get();